Currently looking into reindexing our sql database, and cannot find any information on whether or not the procedure cache would be effected. Any help or information would be great. We are using SQL Server 2005 as our DBMS.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Execution Plan Caching and Reuse lists some of the factors that trigger recompilation:
Since Index Rebuild operations also update the statistics as a side effect, it follows that an index rebuild will trigger a plan invalidation (recompile).