“Excavating” the Heap Table
•A well-designed query and
execution plan won’t “dig deep” just to see last-week’s data!
•This usually implies
that you will drive from a condition that correlates somehow to a
recent event or to a set of recent events, avoiding a path
that touches data for old events.