Chapter 23: Hints

by Jonathan Gennick
  • Jason Brimhall
  • Jonathan Gennick
  • Wayne Sheffield

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 22 and  24. 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.

Keywords

Specific Index Execution Plan Query Plan Query Engine Efficient Plan 
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

© Jason Brimhall, Jonathan Gennick, and Wayne Sheffield 2015

Authors and Affiliations

  • Jason Brimhall
    • 1
  • Jonathan Gennick
    • 1
  • Wayne Sheffield
    • 1
  1. 1.UTUS

Personalised recommendations