Best Practice No-2

The KEEP PLAN query hint changes the recompilation thresholds for temporary tables, and makes them identical to those for permanent tables. Therefore, if changes to temporary tables are causing many recompilations, this query hint can be used.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.