Indexing & Query Optimization Basics — Roadmap Step & Resources
How indexes speed up reads and the write-cost trade-off
- Level: intermediate
- Estimated time: 1 days
- Roadmap: Java + Spring Boot
Before this step
Study resources
- Database Indexing (Article) — Baeldung's clear explanation of how indexes speed up reads at the cost of writes.
- Database Indexing Explained (Video) — A practical explanation of B-tree indexes and the read/write trade-off.
Part of
- Databases & SQL — section
- Java + Spring Boot roadmap — the full learning path