Delete an index

Indexes speed up searches, but they can also slow bulk record updates such as append queries. If you have indexed a field or fields that you don't use to search, sort, or join, and you perform operations that perform bulk record updates that you want to speed up, delete the index. Deleting an index doesn't delete the field or the data in the field.

To delete a single-field index

1. Open the table in Design view.
   
   
2. In the upper portion of the window, click the field whose index you want to delete.
   
   
3. In the lower portion of the window on the General tab click in the Indexed property box, and then click No.

To delete a multiple-field index

1. Open the table in Design view.
   
   
2. Click Indexes on the toolbar.
   
   
3. In the Indexes window, select the rows containing the index you want to delete and press the DELETE key. This removes only the index, not the field itself.