sql-optimization-patterns

Analyze EXPLAIN output to identify execution bottlenecks like sequential scans or nested loops. This Skill helps diagnose slow SQL queries by interpreting query plans and implementing targeted indexing or query modifications to resolve performance issues.

Eliminate N+1 query problems by applying optimization patterns like eager loading or batch fetching. This Skill provides strategies to refactor inefficient data access logic in relational databases, significantly reducing redundant query execution overhead.

Optimize database pagination by replacing OFFSET clauses with keyset pagination patterns. This Skill implements efficient pagination techniques in SQL queries to prevent performance degradation when navigating deep into large relational datasets.

Need B-Tree or GIN indexing strategies when query tuning reveals missing indexes or slow filtering operations. This Skill guides creating various index types to maximize efficiency based on specific SQL execution mechanics and data types.

Yes, understanding SQL execution mechanics and database indexing principles is required. This Skill requires prerequisite knowledge of how relational databases process queries internally to effectively apply advanced optimization patterns.

Slow load times despite indexes occur due to inefficient query structures or suboptimal execution plans. Use this Skill to run EXPLAIN ANALYZE, identify bottlenecks, and implement correct index usage or query modifications for better performance.