Query Optimization and Execution

  • Dmitri Korotkevitch


SQL Server Query Processor is perhaps the least visible and least well-known part of SQL Server. It does not expose a large set of public features, and it allows very limited control in a documented and supported way. It accepts a query as input, compiles and optimizes it to generate the execution plan, and finally executes it.


Hash Table Nest Loop Execution Plan Query Optimizer Query Execution 

Copyright information

© Dmitri Korotkevitch 2016

Authors and Affiliations

  • Dmitri Korotkevitch
    • 1
  1. 1.TampaUSA

Personalised recommendations