|
Sometimes it is necessary to rebuild an index. For example, when an index becomes skewed over time as indicated by the sa_index_density system procedure. When you rebuild an index, you rebuild the physical index. All logical indexes that use the physical index benefit from the rebuild operation; you do not need to perform a rebuild on all logical indexes that share the same physical index. For more information about logical and physical indexes, see Index sharing using logical indexes.
Connect to the database as a DBA user or as the owner of the table on which the index is created.
In the left pane, open the Indexes folder.
Select the desired index and then choose File > Rebuild.
Connect to the database as a DBA user or as the owner of the table associated with the index.
Execute an ALTER INDEX ... REBUILD statement.
The following statement rebuilds the IX_customer_name index on the Customers table:
ALTER INDEX IX_customer_name ON Customers REBUILD;