Alter index enable index disable index

​

USE AdventureWorks
GO
—-Diable Index
ALTER INDEX [IX_StoreContact_ContactTypeID] ON Sales.StoreContact DISABLE
GO
—-Enable Index
ALTER INDEX [IX_StoreContact_ContactTypeID] ON Sales.StoreContact REBUILD
GO
—-Diable Index
ALTER INDEX [IX_cid] ON Sales.StoreContact DISABLE
GO
—-Enable Index
ALTER INDEX [IX_StoreContact_ContactTypeID] ON Sales.StoreContact REBUILD
GO

Leave a Reply

Your email address will not be published. Required fields are marked *