Enable Indexes

Posted by Bandi under Sql Server category on | Points: 40 | Views : 248
SQL Server doesn't have direct ENABLE command to enable an index.

REBUILD index enables the indexes which are disbled....


ALTER INDEX IX_IndexName ON dbo.TargetTable REBUILD;

Rebuilding index is a periodical task to update the index usage statistics on the server/database.

Comments or Responses

Login to post response