Progress
Database Design
Guide
Deactivating Indexes
Indexes that you seldom use can impair performance by causing unnecessary overhead. If you don’t want to delete a seldom-used index, then deactivate it. Deactivating an index eliminates the processing overhead associated with the index, but does not free up its disk space. For information on how to deactivate indexes refer to the Progress Database Administration Guide and Reference . To learn how to do this using SQL-92, see the Progress SQL-92 Guide and Reference.
NOTE: You would deactivate an index in order to do a bulk load. You would reactivate an index to perform an index rebuild.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |