Query Optimization

This skill provides a comprehensive framework for transforming slow SQL queries into highly efficient code by moving beyond basic improvements toward peak performance. It guides users through establishing rigorous baselines, interpreting complex query plans for SQLite, PostgreSQL, and MySQL, and applying advanced techniques such as Common Table Expressions (CTEs) and window functions. Whether troubleshooting full table scans or restructuring inefficient joins, this resource ensures every optimization is backed by empirical data and thorough correctness verification to prevent common pitfalls like satisficing or incomplete testing.

Key Features

Use Cases