sql-optimization-patterns

What problem does it solve?

This Skill addresses the critical issue of slow database queries and inefficient schema design, which can cripple application performance and increase operational costs. It provides systematic approaches to identify and resolve performance bottlenecks.

Core Features & Use Cases

• EXPLAIN Analysis: Learn to interpret query execution plans to pinpoint performance issues.
• Indexing Strategies: Implement B-Tree, Composite, Partial, and Covering indexes for faster data retrieval.
• N+1 Query Elimination: Transform inefficient data fetching into optimized JOINs or batch operations.
• Use Case: You've identified a report that takes minutes to load due to a slow SQL query. Use this Skill to analyze the query's EXPLAIN plan, suggest appropriate indexes, and rewrite the query for sub-second response times.

Quick Start

Analyze the following SQL query using EXPLAIN and suggest optimization strategies, including indexing: SELECT * FROM orders WHERE customer_id = 123 AND created_at > '2023-01-01';