Claude
Skills
Sign in
Back

query-optimization

Included with Lifetime
$97 forever

SQL query optimization and performance tuning

Backend & APIsscriptsassets

What this skill does


# 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

Related in Backend & APIs