Disabling and dropping indexes

Disabling and dropping indexes

Often an index is created and after some time a database administrator or developer may realize that it is really not needed. As a result, the administrator or developer typically will want to remove the index.In some cases, instead of removing the index, it may be a good idea to disable it.This will allow you to verify how performance is affected without actually dropping the index.

Disable an index using SSMS

1. Open SSMS and connect to a server.
2. Expand the Databases folder.
3. Expand the AdventureWorks2012 database.
4. Expand the Tables folder.
5. Expand the Sales.SalesOrderHeader table.
6. Expand the Indexes folder.
7. Right-click the IX_SalesOrderHeader_OrderDate index and select Disable.

Drop an index using SSMS

1. Open SSMS and connect to a server.
2. Expand the Databases folder.
3. Expand the AdventureWorks2012 database.
4. Expand the Tables folder.
5. Expand the Sales.SalesOrderHeader table.
6. Expand the Indexes folder.
7. Right-click the IX_SalesOrderHeader_OrderDate index and select Delete.

Thanks & Regards

Srikanth Goud– Virtualization Administrator