SQL Optimization Patterns

Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.

Use this skill when

• -Debugging slow-running queries
• -Designing performant database schemas
• -Optimizing application response times
• -Reducing database load and costs
• -Improving scalability for growing datasets
• -Analyzing EXPLAIN query plans
• -Implementing efficient indexes
• -Resolving N+1 query problems

Instructions

• -Clarify goals, constraints, and required inputs.
• -Apply relevant best practices and validate outcomes.
• -Provide actionable steps and verification.