data-analyst-sql-optimization

What problem does it solve?

This Skill helps SQL analysts optimize slow queries using proven patterns, improving performance and reducing debugging time.

Core Features & Use Cases

• Optimization pattern library: catalog of common patterns (N+1, index usage, join optimization, window functions, etc.)
• Before/After examples: show concrete improvements.
• Index recommendations: guidance on indexing strategies.
• Execution plan analysis: how to read EXPLAIN and validate improvements.
• Use Case: optimize a lagging dashboard query to meet SLA.

Quick Start

Provide an example: "optimize this slow query: SELECT * FROM orders WHERE status='completed' AND created_at > '2023-01-01'".