Advertisement

Index Tuning and Statistics

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

Abstract

As discussed in  Chapter 21, SQL Server query performance tuning and optimization requires a multilayered approach. This chapter focuses on the index and statistics tuning aspects of that approach. The following are a few key factors that impact SQL Server query performance:

Keywords

Query Performance Index Fragmentation Data Page Reorganization Process Drop Statistic 
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