Advertisement

Hints

  • Jason Brimhall
  • David Dye
  • Jonathan Gennick
  • Andy Roberts
  • Wayne Sheffield
Chapter

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.

Keywords

Nest Loop Specific Index Execution Plan Query Plan Query Engine 
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 2012

Authors and Affiliations

  • Jason Brimhall
    • 1
  • David Dye
    • 2
  • Jonathan Gennick
    • 3
  • Andy Roberts
    • 4
  • Wayne Sheffield
    • 5
  1. 1.UTUSA
  2. 2.FLUSA
  3. 3.MIUnited States
  4. 4.MAUSA
  5. 5.VAUSA

Personalised recommendations