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 ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
