Part 8 · Storage EngineChapter 26
mmap & Page Cache
The index is not copied into the heap. Hot pages stay resident; cold pages stay on disk.
The question
Why is the second query so much faster?
The structure responsible
Memory mapping and the OS page cache
In this lab: Run identical reads in four access orders and watch locality decide the cost.
building the index…