Dynamic SQL pp 177-207 | Cite as

Parameter Sniffing

  • Edward Pollack
Chapter

Abstract

A critical component that was briefly discussed was the query plan cache. Whenever a query is executed for the first time, an execution plan is generated by the query optimizer. This process is expensive and therefore it is beneficial to minimize the work that is performed by it. Execution plans are placed into the query plan cache when optimization is complete, where they will remain until sufficient changes occur in execution, available memory, or the underlying data to push that plan out of cache.

Keywords

Execution Plan Query Optimizer Query Execution Query Plan Query Tree 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Ed Pollack 2016

Authors and Affiliations

  • Edward Pollack
    • 1
  1. 1.AlbanyUSA

Personalised recommendations