sql-optimization-patterns

Use EXPLAIN ANALYZE to identify query execution bottlenecks. This Skill analyzes query plans to find slow operations, then applies indexing and query rewriting patterns to fix SQL performance issues in production workloads.

SQL optimization patterns for both OLTP and OLAP scenarios include applying B-Tree, partial, and covering indexes, rewriting inefficient joins, and optimizing aggregations to reduce unnecessary data transfer and lower latency.

Design indexing strategies using B-Tree, partial indexes, and covering indexes to accelerate lookups. As data grows, applying these indexing patterns prevents performance regression and significantly improves query response times.

Yes, this Skill applies query optimization patterns across both OLTP and OLAP scenarios. It analyzes representative query batches to recommend indexing and query rewriting patterns that achieve measurable performance improvements.

Query performance regresses after schema changes or data growth due to misaligned execution plans. Fix slow SQL by analyzing query plans and applying targeted optimization patterns like index design and query rewriting.

Rewrite SQL queries using optimization patterns that streamline joins and aggregations. This avoids unnecessary data transfer and improves execution efficiency, resulting in measurable latency reductions for production applications.