Chapter 4. Index Analysis

The right index on the right column, or columns, is the basis on which query tuning begins. On the other hand, 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 the 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 of an index

  • General recommendations for index design

  • Clustered and nonclustered index behavior and comparisons

  • Recommendations for clustered and nonclustered ...

Get SQL Server 2008 Query Performance Tuning Distilled now with O’Reilly online learning.

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