The Secret Life of SQL: How to Optimize Database Performance
summary
Explains concrete rules and fixes: how indexes work left-to-right, when to use index prefixes for long varbinary paths, why OR prevents index use in MySQL and how rewriting with UNION cuts a minute-long query to ~11 ms, when to FORCE or USE an index (FORCE INDEX drops a 40s sort to ~1 ms), and when denormalizing user flags and using ChatOps commands like .mysql dead-indexes and in-Slack EXPLAINs measurably improves API response rates.
AI-written summary · about
chapters (6)
- 0:00Introduction
- 0:37Overview
- 6:11Indexing
- 8:28Index Prefixes
- 12:07Use an OR
- 18:37Avoid redundant data across tables
related talks
46mSupercharge Your SQL with Indexes: a Practical Introduction
49mIt’s Not Always About the Index: The Hidden Secrets of Query Performance
36mFor performance, go to page 5: Indexes
21mWriting High Performance SQL Statements
01mHow well do you know your MySQL Indexes?
41mMySQL Query Optimization Best Practices and Indexing
34mMySQL and InnoDB Performance for the Rest of Us
47mMySQL Indexing Best Practices