How to: Reorganize an Index (SQL Server Management Studio)
This topic describes how to reorganize an index or all indexes on a table by using Object Explorer in SQL Server Management Studio. Reorganizing an index uses minimal system resources. It defragments the leaf level of clustered and nonclustered indexes on tables and views by physically reordering the leaf-level pages to match the logical, left to right order of the leaf nodes. Reorganizing also compacts the index pages. Compaction is based on the existing fill factor value. For more information, see Reorganizing and Rebuilding Indexes.
To reorganize an index
In Object Explorer, connect to an instance of the SQL Server 2005 Database Engine and then expand that instance.
Expand Databases, expand the database that contains the table with the specified index, and then expand Tables.
Expand the table in which the index belongs and then expand Indexes.
Right-click the index to reorganize and then click Reorganize.
To specify that all pages that contain large object (LOB) data are also compacted, select the Compact large object column data check box.
The LOB data types are image, text, ntext, varchar(max), nvarchar(max), varbinary(max), and xml. Compacting this data can improve disk space use.
To disable large object data compaction, clear the Compact large object column data check box.
To start the reorganize operation, click OK.
To reorganize all indexes on a table
In Object Explorer, connect to an instance of the SQL Server 2005 Database Engine and then expand that instance.
Expand Databases, expand the database that contains the table with the specified indexes, and then expand Tables.
Expand the table in which the indexes belong.
Right-click Indexes and then click Reorganize All.
To specify that all pages that contain large object (LOB) data are also compacted, select the Compact large object column data check box.
The LOB data types are image, text, ntext, varchar(max), nvarchar(max), varbinary(max), and xml. Compacting this data can improve disk space use.
To disable large object data compaction, clear the Compact large object column data check box.
To start the reorganize operation, click OK.
See Also
Tasks
How to: Rebuild an Index (SQL Server Management Studio)
Concepts
How to: Modify an Index (SQL Server Management Studio)
Other Resources
Database Engine How-to Topics
Indexes How-to Topics
ALTER INDEX (Transact-SQL)