• Article

Rebuild Indexes (General Page)

Use this dialog box to rebuild an index. Using this dialog box is equivalent to running ALTER INDEX WITH REBUILD. When connected to SQL Server 2000, this dialog box is equivalent to running DBCC DBREINDEX. To access it, expand a table in Object Explorer, right-click Indexes ora 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 type of the index: Clustered, Nonclustered, Spatial, 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.