Tradeoffs
What to cache?
- Cost of Cache operator must be smaller than savings obtained by this kind of pre-caching
When to cache?
- late so that only relevant objects are cached
- early so that other operators are not affected
N.B. Cache operators affect the cost of other (lower) operators in the plan