What does an index cost? Write amplification, storage, and over-indexing.

Answer preview

Every index is a second copy of part of your data that must be kept transactionally consistent. Reads get faster; every INSERT, UPDATE, and DELETE pays to maintain every index, and the table's disk footprint and backup time grow with it.…