MS SQL Server 2012 - DBA Articles

Reorganize Indexes

Reorganizing an index is always executed online. 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.
The following example describes to reorganize the IX_Employee_Nonclustered index on the dbo.Employee table.

-- Example 156 --

USE EBusiness

ALTER INDEX IX_Employee_Nonclustered ON dbo.Employee

REORGANIZE

Query Output Screen

The following example describes to reorganize ALL indexes on dbo.Employee table.

-- Example 157 --

USE EBusiness

ALTER INDEX ALL ON dbo.Employee

REORGANIZE

Query Output Screen

* * * * *

Your Comment To AUTHOR