Abstract
SQL Server Query Optimizer uses a cost-based model when choosing an execution plan for queries. It estimates the costs 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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2016 Dmitri Korotkevitch
About this chapter
Cite this chapter
Korotkevitch, D. (2016). Statistics. In: Pro SQL Server Internals. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-1964-5_3
Download citation
DOI: https://doi.org/10.1007/978-1-4842-1964-5_3
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-1963-8
Online ISBN: 978-1-4842-1964-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books