Advertisement

Chapter 24: Index Tuning and Statistics

By Jason Brimhall
  • Jason Brimhall
  • Jonathan Gennick
  • Wayne Sheffield

Abstract

As discussed in  Chapter 22, 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 Event Session Data Page Reorganization Process 
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