New answers tagged execution-plan
AFAIK, you cannot force a plan to stay in cache. However, a query can be thrown out of the cache for several reasons. Read a blog about execution plans. It states some reasons why execution plans get invalidated: Changing the structure or schema of a table referenced by the query Changing an index used by the query Dropping an index used by the ...
Top 50 recent answers are included