What developers need to know about indexes
summary
Explains what developers need to know about database indexes: what they are, how they work, and when to use them to improve query performance. Covers types of indexes and practical considerations such as trade-offs, maintenance costs, and how indexes affect reads and writes.
AI-written summary · about
chapters (7)
- 0:00SQL indexes intro
- 4:12Index structure and operation
- 12:34Multi-column indexing
- 20:15Query impact
- 28:47Index types and use cases
- 35:22Optimization best practices
- 40:36Q&A
related talks
42mThings every developer absolutely, positively needs to know about database indexing
47mThe Whole Truth About Indexes in PostgreSQL
02h 01mIndexes in PostgreSQL. How to Decide What to Create
36mFor performance, go to page 5: Indexes
01mHow well do you know your MySQL Indexes?
53mIndexing Internals for Developers & DBAs
48mMySQL Indexing - Do It Right or Die
47mMySQL Indexing Best Practices