Optimizing Indexes

A key factor in achieving minimum disk I/O for all database queries is making sure that good indexes are created and then maintained. The topics in this section provide information to help you create indexes efficiently and maintain index performance thereafter.

In This Section

Topic Description

Reorganizing and Rebuilding Indexes

Describes methods to defragment indexes and optimize index disk space.

Fill Factor

Describes how to use the FILLFACTOR option to fine-tune index data storage and performance.

Performing Index Operations Online

Describes how to use the ONLINE index option to provide user access to data during index operations.

Configuring Parallel Index Operations

Describes the max degree of parallelism option and its use in index operations.

Index Statistics

Describes how the query optimizer uses statistics to develop optimal query plans. Discusses how to disable automatic statistics collections and manually create statistics.

Bulk Copy and Indexes

Provides guidance on improving the performance of bulk copy operations when the target table contains clustered and nonclustered indexes.

Choosing a Recovery Model for Index Operations

Lists index operations and the type of logging available for these operations based on the recovery model of the database.

See Also

Concepts

Designing Indexes
Implementing Indexes
Indexes

Other Resources

Understanding Indexes

Help and Information

Getting SQL Server 2005 Assistance