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