how to disable indexes for temporarily

Posted by Bandi under Sql Server category on | Points: 40 | Views : 683
Disabling a nonclustered index will delete the index pages and the space is freed in the database.

ALTER INDEX IX_IndexName ON dbo.TargetTable DISABLE;

It will be more useful if you are doing huge DML operations on the table at frequent times... You can also re-enable the indexes later if you need...

Comments or Responses

Login to post response