Reorganize Indexes (General Page)

Reorganize Indexes (General Page)

Use this dialog box to reorganize an index. This operation is equivalent to DBCC INDEXDEFRAG. To access this dialog box, expand a table in Object Explorer, right-click Indexes or right-click a specific index, and then click Reorganize or Reorganize 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.

Compact large object column data

If this check box is selected, the operation compacts all pages containing large object data. The data types image, text, ntext, varchar(max), nvarchar(max), varbinary(max), and xml are large object data types. Compacting this data can result in better disk space utilization. The option is ignored if large object columns are not present.

Community Additions

ADD
Show:
© 2016 Microsoft