Tag Info

Hot answers tagged


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 ...

Only top voted, non community-wiki answers of a minimum length are eligible