Inserting secondary index records typically requires random disk I/O if the target index leaf page is not memory-resident. The Change Buffer intercepts and caches these modifications in the buffer pool.
When the page is subsequently loaded by a query or reconciled by background master threads, changes are merged cleanly, transforming random read/writes into efficient deferred operations.