Determining Index Disk Space Requirements

Disk space is an important consideration when you create, rebuild, or drop indexes. Inadequate disk space can degrade performance or even cause the index operation to fail.

In This Section

Topic	Description
Disk Space Requirements for Index DDL Operations	Lists index DDL operations that do and do not require additional temporary disk space. Describes the objects and processes that use temporary disk space during the index operation.
Index Disk Space Example	Shows the process of determining the required disk space for offline and online index operations.
Transaction Log Disk Space for Index Operations	Provides recommendations for minimizing the effect of large-scale index operations on the transaction log.

Disk Space Requirements for Index DDL Operations

Lists index DDL operations that do and do not require additional temporary disk space.

Describes the objects and processes that use temporary disk space during the index operation.

Index Disk Space Example

Shows the process of determining the required disk space for offline and online index operations.

Transaction Log Disk Space for Index Operations

Provides recommendations for minimizing the effect of large-scale index operations on the transaction log.

Reference

ALTER INDEX (Transact-SQL)

CREATE INDEX (Transact-SQL)

DROP INDEX (Transact-SQL)

Estimating the Size of a Clustered Index

Estimating the Size of a Nonclustered Index

Placing Indexes on Filegroups

Reorganizing and Rebuilding Indexes

Determining Index Disk Space Requirements

In This Section

Reference

See Also

Concepts

Help and Information

Ytterligare resurser