A query plan is a set of steps generated by the database engine to retrieve data. Query plans are produced by the query optimizer from SQL statements. SQL Server automatically caches query plans and try to reuse them whenever possible. For many applications (such as OLTP transactional applications), plan reuse is a very good thing since […]
Posts Tagged ‘WITH RECOMPILE’
July 15, 2011 by Francois · 1 Comment
Filed under: Performance
Social Tagging: local variable • OPTION (RECOMPILE) • plan cache • query plan • set statistics profile • statistics • sub-optimal query plan • TSQL • WITH RECOMPILE
Filed under: Performance
Social Tagging: local variable • OPTION (RECOMPILE) • plan cache • query plan • set statistics profile • statistics • sub-optimal query plan • TSQL • WITH RECOMPILE
RSS