SQL Server 2017 Query Performance Tuning: Troubleshoot and Optimize Query Performance

© Grant Fritchey 2018

Grant FritcheySQL Server 2017 Query Performance Tuninghttps://doi.org/10.1007/978-1-4842-3888-2_8

8. Index Architecture and Behavior

Grant Fritchey¹ 

(1)

Grafton, Massachusetts, USA

 

The right index on the right column, or columns, is the basis on which query tuning begins. A missing index or an index placed on the wrong column, or columns, can be the basis for all performance problems starting with basic data access, continuing through joins, and ending in filtering clauses. For these reasons, it is extremely important for everyone—not just a DBA—to understand the different indexing techniques that can be used to optimize the database design.

In this chapter, I cover the following topics:

• What an index is

• The benefits and overhead ...