Index Tuning and Statistics

By Jason Brimhall

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:

  • Appropriate indexing : Your table indexes should be based on your high-priority or frequently executed queries. If a query is executing thousands of times a day and is completing in two seconds but could be running in less than one second with the proper index, adding this index could reduce the I/O pressure on your ...

Get SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.