How to
disable and enable an index? |
Execute the following Microsoft SQL Server Transact-SQL (T-SQL) script in Management Studio (SSMS) Query Editor, SQLCMD or other client software
to disable an index, check its status,
enable an index and check the status again:
USE AdventureWorks;
ALTER INDEX [IX_SalesOrderHeader_CustomerID]
ON Sales.SalesOrderHeader DISABLE
GO
select * from sys.sysindexes where name='IX_SalesOrderHeader_CustomerID'
GO
ALTER INDEX [IX_SalesOrderHeader_CustomerID] ON Sales.SalesOrderHeader
REBUILD
GO
select * from sys.sysindexes where name='IX_SalesOrderHeader_CustomerID'
GO
|
|
|
|
|
|
|
|
|