Posts Tagged ‘plan cache’

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 […]