how to disable indexes for temporarily

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

Syntax:
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