query-optimization

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