THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance » Query Optimizer » Parameter Sniffing   (RSS)
  • The Query Optimizer and Parameter Sniffing

      As we all know, the SQL Server Query Optimizer uses statistics to estimate the cardinality and selectivity of predicates of a query to produce an optimal execution plan. The Query Optimizer accomplishes this by first inspecting the values of the query parameters. This behavior is called parameter sniffing and it is a good thing. Getting an ...
    Posted to Benjamin Nevarez (Weblog) by Ben Nevarez on August 27, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement