sql-optimization-patterns

SQL query optimization patterns cover join rewrites, pagination strategies, aggregation, and subquery flattening. This Skill provides concrete examples and decision flows to transform inefficient queries into high-performance ones across PostgreSQL and MySQL environments.

Yes, the SQL optimization approach works with both PostgreSQL and MySQL environments. It provides ready-to-execute examples, indexing strategies, and query tuning patterns specifically tailored for debugging performance issues across both database systems.

The best way to choose indexes is by matching them to your query's filter, join, and grouping conditions. This Skill offers indexing strategies that explain when to apply composite, partial, or expression indexes for optimal database performance.

You should avoid query rewrites when the existing query plan already utilizes optimal indexes and low-cost join operations. This Skill emphasizes using EXPLAIN ANALYZE first to verify that a performance bottleneck genuinely exists before applying structural changes.