Database Indexing — Roadmap Step & Resources
B-tree indexes, composite indexes and how indexing trades write speed for read speed
- Level: intermediate
- Estimated time: 1 days
- Roadmap: System Design
Before this step
Interview questions
- Why can adding too many indexes hurt write performance?
Study resources
- Indexes (Article) — MongoDB's official manual on how indexes speed up queries.
- Database Indexing Explained (Video) — A practical explanation of B-tree indexes and the read/write trade-off they introduce.
Part of
- Databases & Storage at Scale — section
- System Design roadmap — the full learning path