query-optimization
SQL查询优化和性能调优
📖 中文导读:SQL查询优化和性能调优 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。
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