Advertisement

Statistics

  • Dmitri Korotkevitch
Chapter

Abstract

SQL Server Query Optimizer uses a cost-based model when choosing an execution plan for queries. It estimates the cost of the different execution plans and chooses the one with the lowest cost. Remember, however, that SQL Server does not search for the best execution plan available for the query, as evaluating all possible alternatives is time consuming and expensive in terms of the CPU. The goal of Query Optimizer is finding a good enough execution plan, fast enough.

Keywords

Execution Plan Query Optimizer Query Execution Leftmost Column Statistic Column 
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

© Dmitri Korotkevitch 2014

Authors and Affiliations

  • Dmitri Korotkevitch
    • 1
  1. 1.FLUnited States

Personalised recommendations