database-performance

Slow queries can be identified and optimized by analyzing EXPLAIN plans to reveal execution bottlenecks, then creating missing indexes or rewriting the query logic. This Skill interprets query plans and recommends specific index strategies and rewrites tailored to your workload.

EXPLAIN plans show how the database executes a query, revealing which indexes are used, table scan costs, and join operations. Interpreting these plans identifies bottlenecks like missing indexes or inefficient join orders, guiding targeted optimization.

Index analysis through query profiling and workload review reveals which indexes are accessed and which remain unused. This Skill discovers missing indexes that would speed up queries and identifies unused indexes candidates for removal to reduce storage and write overhead.

Yes. Query profiling adapts to schema changes by re-analyzing workloads and execution plans as tables and columns evolve. This Skill detects performance regressions from schema modifications and recommends index adjustments and query rewrites for the updated structure.

Workload analysis prioritizes optimization by profiling all slow queries together, identifying common bottlenecks and missing indexes across the set. This Skill generates a ranked list of index creation and removal suggestions that improve overall system performance.

Not always. Index optimization alone often resolves slow queries, but some cases benefit from query rewrites. This Skill recommends both approaches: practical index strategies first, with rewrite suggestions when indexing alone cannot eliminate bottlenecks.