Saturday, September 16, 2006 9:37 AM
xmldeveloper
Do you know what your plan cache contains ?
If you want the complete answer you should take a look at the following post What are the different cached objects in the plan cache? from the SQL Programmability & API Development Team Blog.
[quote]
The following caches are included in procedure cache :
- Compiled Plans
- Execution plans
- Algebrizer tree
- Extended Procs
- Inactive Cursors
[/quote]