Lowell (6/7/2011)
thanks for the clarification Gail!you said "... If a plan is never cached, it won't appear in the query stats DMV at all...", can you clarify?
I thought every query got a query plan that is created and thus was cached, but might not ever be reused by another subsequent sql, due to ad hoc char by char differences and stuff...can you think of an example where a plan doesn't get cached at all?
There are a fairly large number of situations in which plans are not cached. Details are at http://technet.microsoft.com/en-us/library/cc966425.aspx
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon