Archives: December 2009
It is sometimes said that trivial execution plans are not cached and queries that have such plans are compiled on every execution. So is that true? To effectively answer this question, we must first establish what a trivial plan is.
A trivial plan is essentially a plan for a query… Read more