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