O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Index Maintenance and Tuning

Maintaining indexes is an ongoing operation. Because of factors such as page splits and updates to index branch and leaf pages, the index often becomes fragmented. Even though the data is stored in a logically contiguous manner, with time it is no longer physically contiguous. Thus, the indexes should be reorganized occasionally. In this section, you will learn some of the fundamentals for discovering information about indexes and how to maintain indexes.

Monitoring Indexes

Monitoring Indexes might be a slight misnomer. It really is more of a task of investigating indexes, determining their effectiveness, and determining whether these indexes are being used. Whether an index is used really depends on how effective it ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required