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 |
|---|---|
Describes methods to defragment indexes and optimize index disk space. |
|
Describes how to use the FILLFACTOR option to fine-tune index data storage and performance. |
|
Describes how to use the ONLINE index option to provide user access to data during index operations. |
|
Describes the max degree of parallelism option and its use in index operations. |
|
Describes how the query optimizer uses statistics to develop optimal query plans. Discusses how to disable automatic statistics collections and manually create statistics. |
|
Provides guidance on improving the performance of bulk copy operations when the target table contains clustered and nonclustered indexes. |
|
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