Delete an index (ADP)

Indexes can slow INSERT, UPDATE, and DELETE performance. If you find that an index hinders overall performance or you no longer need it, you can delete it.

1. In the Database window, cick Database Diagrams under Objects, click the database diagram you want to open, and then click Design on the database window toolbar.
2. In your database diagram, select the table whose index you want to delete, right-click the table, and choose Properties from the shortcut menu.
3. Choose the Indexes/Keys tab.
4. From the Column Name list, select the index you want to delete.
5. Choose Delete.

   Caution   Choosing Delete will result in an action that cannot be undone without losing all other changes made to the database diagram. To undo this action, close this database diagram and all other open database diagrams and Table Designer windows without saving the changes.

The index is deleted from the database when you save your database diagram.