Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Explain the maintenance cost every index imposes on writes.
- Explain what over-indexing is, and why it is a real, common mistake.
- Explain write amplification caused by having many indexes on one table.
- Decide whether a proposed index is worth its ongoing cost.
Every page so far in this level has focused on how an index speeds up reads. This page covers the other half of the trade, introduced briefly on the first page of this level. It covers the ongoing cost every index imposes, and when that cost outweighs the benefit.