Multiple ChoiceBeginner 45s
Index write amplification
Every write to a table has a secondary B-tree index on a frequently updated column. What is the main cost?
Options
- 1Reads become slower because the index goes stale and must be repaired before any lookup returns rows
- 2The entire index is rebuilt from scratch on every insert, so each write triggers a full scan and sort
- 3Each write also updates the index B-tree, adding write amplification and page splits
- 4Foreign keys on other tables are disabled while the index updates, breaking referential integrity
Think you can answer under pressure?
Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.