Database Optimization

This skill optimizes database performance including query optimization, indexing strategies, N+1 problem resolution, and caching implementation.

When to Use This Skill

• When optimizing slow database queries
• When fixing N+1 query problems
• When designing indexes
• When implementing caching strategies
• When optimizing database migrations
• When improving database performance

What This Skill Does

1. Query Optimization: Analyzes and optimizes SQL queries
2. Index Design: Creates appropriate indexes
3. N+1 Resolution: Fixes N+1 query problems
4. Caching: Implements caching layers (Redis, Memcached)