Use this dialog box to reorganize an index. Using this dialog box is equivalent to running DBCC INDEXDEFRAG. To access it, expand a table in Object Explorer, right-click Indexes or a specific index, and then click Reorganize or Reorganize All.
Displays the name of the selected index.
Displays the name of the table on which the index is defined.
Displays the type of the index: Clustered, Nonclustered, Spatial, or XML.
Displays the percent of fragmentation found in the index.
Displays the progress of the index reorganization operation.
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.