Rebuild Indexes (General Page)
Use this dialog box to rebuild an index. When connected to SQL Server 2005, this operation is equivalent to executing ALTER INDEX WITH REBUILD. When connected to SQL Server 2000, this operation is equivalent to DBCC DBREINDEX (Transact-SQL). To access this dialog box, expand a table in Object Explorer, right-click Indexes or right-click a specific index, and then click Rebuild or Rebuild All.
- Index name
Displays the name of the selected index.
- Table name
Displays the name of the table on which the index is defined.
- Index type
Displays the index type (Clustered, Nonclustered, or XML).
- Total fragmentation
Displays the percent of fragmentation found in the index.
- Status
Displays the progress of the index reorganization operation.
- Message
Displays error messages produced during the operation.
See Also
Other Resources
Creating Indexes (Database Engine)
ALTER INDEX (Transact-SQL)