Progress
Basic Database
Tools
Deactivating an Index
Follow these steps to deactivate an index:
- Choose Schema
Index Editor. Progress alphabetically lists all the tables defined for your database.
- Select a table. Progress lists the indexes defined for that table.
- Select the index you want to deactivate.
- Choose the MakeInactive option from the menu at the bottom of the window. Progress prompts you to verify that you want to make the selected index inactive.
- Choose Yes to deactivate the index.
- Choose Exit to apply the change. Progress 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.
- Choose Apply Changes. Progress returns you to the Data Dictionary main window.
NOTE: For more information on indexes, see the chapter on Progress performance in the Progress Database Administration Guide and Reference.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |