Try OpenEdge Now
skip to main content
Basic Database Tools
Index Tasks : Modifying an index : Deactivating an index
 

Deactivating an index

You can deactivate an active table index.
Note: To see which indexes are currently active, run a Detailed Table Report or a Quick Index Report. Inactive indexes are flagged with an "i."
To deactivate an index:
1. Choose Schema > Index Editor. The Index Editor alphabetically lists all the tables defined for your database.
2. Select a table. The Index Editor lists the indexes defined for that table.
3. Select the index you want to deactivate.
4. Choose MakeInactive. The Index Editor prompts you to verify that you want to make the selected index inactive.
5. Choose Yes to deactivate the index.
6. Choose Exit. The Data Dictionary displays an alert box asking if you want to apply or undo the changes to the database, or if you want to make other changes.
7. Choose Apply Changes. The Data Dictionary main window appears.
Note: For more information about indexes, see OpenEdge Data Management: Database Administration.