Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Dumping and Loading : Specialized dump and load techniques : Saving disk space by deactivating indexes : Deactivating indexes from the Data Dictionary
 
Deactivating indexes from the Data Dictionary
To deactivate an individual index from a graphical user interface:
1. Access the Data Dictionary tool.
2. Click the Index icon.
3. Click the index you want to deactivate.
4. Click the Index Properties button. The Index Properties dialog box appears.
5. Select the table that contains the index you want to deactivate. The Data Dictionary lists the indexes defined for the selected database.
6. Click the Active toggle box.
7. Click the Save button. The Data Dictionary prompts you to verify that you want to deactivate the index.
8. Verify that you want to deactivate the index. The Data Dictionary deactivates the index.