Databases

Write amplification

One logical write causes several physical writes - to the log, the data pages, and every affected index.

It explains why adding an index slows writes, why full-page writes after a checkpoint cause a visible I/O spike, and why an update touching an indexed column costs more than one that does not.

Explained in depth

Implemented by

Learn it in context

Related concepts