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