For performance, go to page 5: Indexes
summary
Practical cookbook on database indexing with concrete MySQL actions and tradeoffs: how storage uses B+ tree layouts for fast lookups, when a composite index speeds multi-column filters, why column order and cardinality determine usefulness, and how EXPLAIN ANALYZE and the slow query log reveal actual row access counts. Covers covering and prefix indexes, functional and hash approaches, foreign keys auto-indexing, explain JSON output, space/write overhead of indexes, and rules for when to add or remove them.
AI-written summary · about
chapters (11)
- 0:00Introduction
- 3:17Performance and caching
- 8:39Database indexes matter
- 15:44Full table scans
- 18:21Single-column indexes
- 21:53B-trees in indexes
- 23:40Query plans with EXPLAIN
- 25:07Composite indexes
- 27:39Index cardinality and ordering
- 30:05Index types
- 32:16Indexing best practices
related talks
47mMySQL Indexing Best Practices
46mSupercharge Your SQL with Indexes: a Practical Introduction
49mIt’s Not Always About the Index: The Hidden Secrets of Query Performance
42mThings every developer absolutely, positively needs to know about database indexing
50mHow to choose the right index
01mHow well do you know your MySQL Indexes?
21mWriting High Performance SQL Statements
01h 30mMySQL Indexes, Histograms, Locking Options, and Other Ways to Speed Up Your Queries