Part 9 · Production Query EngineChapter 28
Caching
Four layers, and hit rate alone will lie to you. Only deterministic, score-free work is cacheable.
The question
What can be reused, and how would I know it is working?
The structure responsible
Page cache, filter cache, result cache
In this lab: Drive an LRU with a real query stream and watch hit, miss and eviction rates disagree.
building the index…