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.
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