---

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