Abstract
SQL Server’s query optimization process is responsible for producing a query execution plan when a SELECT query is executed. Typically SQL Server will choose an efficient plan over an inefficient one. When this doesn’t happen, you will want to examine the query execution plan, table statistics, supporting indexes, and other factors that are discussed in more detail in Chapters 21 and 23. Ultimately, after researching the query’s performance, you may decide to override the decision-making process of the SQL Server query optimizer by using hints.
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
© 2012 Jason Brimhall
About this chapter
Cite this chapter
Brimhall, J., Dye, D., Gennick, J., Roberts, A., Sheffield, W. (2012). Hints. In: SQL Server 2012 T-SQL Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-4201-7_22
Download citation
DOI: https://doi.org/10.1007/978-1-4302-4201-7_22
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-4200-0
Online ISBN: 978-1-4302-4201-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books