domains / families / data / sql-optimization-patterns

sql-optimization-patterns

combined

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance. Diagnose slow SQL with query plans, preserve query results, and verify indexing or query changes against representative data.

When to use

• 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

When not to use

• The task is unrelated to sql optimization patterns
• You need a different domain or tool outside this scope
• Use this skill only when the task clearly matches the scope described above.
• Do not treat the output as a substitute for environment-specific validation, testing, or expert review.
• Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.

Skill page

Conflict

The two copies share the same high-level scope and resource pointer, but the second copy adds material safety and verification constraints that the first lacks. The first copy is a generic wrapper that defers to a playbook, while the second copy specifies read-only starts, authorization for DDL, result-set comparison before performance comparison, and the side-effect risks of EXPLAIN ANALYZE. Crowning the first copy would hide these real operational constraints, and crowning the second would lose the first's broader framing. They overlap but each has steps the other lacks, so they should be combined.