--- name: query-optimization description: SQL query optimization and performance tuning sasmp_version: "1.3.0" bonded_agent: 01-sql-fundamentals bond_type: PRIMARY_BOND --- # Query Optimization Skill ## Overview Optimize SQL queries for maximum performance across different database systems. ## Topics Covered ### Query Analysis - EXPLAIN plans - Execution statistics - Cost-based optimization - Query profiling - Wait event analysis ### Indexing Strategy - B-tree indexes - Covering indexes - Partial indexes - Index selection - Index maintenance ### Query Patterns - JOIN optimization - Subquery alternatives - Aggregate optimization - Pagination patterns - Bulk operations ### Database Specific - PostgreSQL optimization - MySQL tuning - SQL Server hints - Oracle optimization - Cloud DB optimization ## Prerequisites - SQL fundamentals - Database internals basics ## Learning Outcomes - Analyze query plans - Create effective indexes - Rewrite slow queries - Tune database performance