Supercharge Your SQL with Indexes: a Practical Introduction
summary
Uses MySQL InnoDB and B+ trees, runs live EXPLAIN and SHOW INDEX checks, and creates indexes on the fly to measure impact—examples show a query drop from ~10s to ~2ms and index selectivity stepping from 0.002 to 0.037 to ~0.9. Demonstrates prefix index savings (index size ~28MB → ~13MB), JSON indexing via generated columns, and multicolumn index left‑to‑right rules. Recommends small primary keys, weighs autoincrement vs UUID/ULID, and cites Prisma Optimize.
AI-written summary · about
chapters (10)
- 0:00SQL indexes introduction
- 10:50B-tree indexes explained
- 17:11Primary keys for performance
- 23:50Secondary indexes overview
- 28:10Prefix indexes for strings
- 33:07Multi-column indexes order
- 37:04JSON indexing with columns
- 40:15Index management best practices
- 43:25Q&A function-based indexes
- 45:09Q&A indexing strategies
related talks
36mFor performance, go to page 5: Indexes
49mIt’s Not Always About the Index: The Hidden Secrets of Query Performance
47mMySQL Indexing Best Practices
25mThe Secret Life of SQL: How to Optimize Database Performance
42mThings every developer absolutely, positively needs to know about database indexing
01mHow well do you know your MySQL Indexes?
01h 30mMySQL Indexes, Histograms, Locking Options, and Other Ways to Speed Up Your Queries
30mMySQL Indexes and Histograms to Speed Up Your Queries