Stop Indexing the Query
summary
Methodology identifies low‑ROI queries by computing logical and physical reads divided by rows desired and reads to rows > 8 filters the worst candidates, then group queries by table to find many needles at once. The process penalize by execution count so high‑frequency small‑result queries surface, validate missing index recommendations, inspect plans for scans, key lookups, spools or implicit conversions, measure before/after, watch data churn (≥50% daily warns against indexing), and remove duplicate indexes to avoid DML overhead.
AI-written summary · about
chapters (10)
- 0:00Holistic workload approach
- 1:31Indexing methodology
- 3:53Defining inefficiency
- 7:03Analyzing query performance
- 11:17Data-driven prioritization
- 14:09Inspecting query plans
- 19:07Index validation and cleanup
- 23:29Managing data churn
- 25:52Iterative optimization
- 30:28Cloud, cost, and conclusion
related talks
41mStop Indexing the Query
50mHow to choose the right index
53mIndexing Internals for Developers & DBAs
46mA Rocket Scientist Perspective on Index Column Selection
34mVoila, Indexes! A Look at Some Simple Preventative Magick
52mPostgreSQL Index Strategy Guide
41mMySQL Query Optimization Best Practices and Indexing
01mHow well do you know your MySQL Indexes?