Kbase P5017: Are any actions necessary after adding an index via the Data
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/03/2003 |
|
Status: Unverified
GOAL:
Are any actions necessary after adding an index via the Data Dictionary in order to utilize it?
FIX:
When an index is created as "active" via the Data Dictionary, it is built immediately after the change is committed. No further actions are required to utilize or populate this index.
When an index is created as "inactive", it needs to be activated before being accessible from an application. Once the index is committed as "inactive", it can be activated using "proutil dbname -C idxbuild" or "proutil dbname -C idxfix". This can only be done when the database is offline