
query-optimization
SQL query optimization and performance tuning
SQL query optimization and performance tuning
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
You Might Also Like
Related Skills

zig-system-calls
Guides using bun.sys for system calls and file I/O in Zig. Use when implementing file operations instead of std.fs or std.posix.
oven-sh
bun-file-io
Use this when you are working on file operations like reading, writing, scanning, or deleting files. It summarizes the preferred file APIs and patterns used in this repo. It also notes when to use filesystem helpers for directories.
anomalyco
vector-index-tuning
Optimize vector index performance for latency, recall, and memory. Use when tuning HNSW parameters, selecting quantization strategies, or scaling vector search infrastructure.
wshobson
similarity-search-patterns
Implement efficient similarity search with vector databases. Use when building semantic search, implementing nearest neighbor queries, or optimizing retrieval performance.
wshobson
dbt-transformation-patterns
Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.
wshobson
event-store-design
Design and implement event stores for event-sourced systems. Use when building event sourcing infrastructure, choosing event store technologies, or implementing event persistence patterns.
wshobson