Kbase P11656: What is the fastest way to create an index?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/12/2010 |
|
Status: Verified
GOAL:
What is the fastest way to add an index in a Progress database?
GOAL:
How do I save time when adding an index?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
Depending on the database server configuration, create the new index as inactivated and activate it later by using proutil idxbuild.
This result vary from case by case but it might be faster for tables that contains a very large number of records.
Follow these steps to create and activate the index:
1. Backup the database
2. Create the index in dictionary and turn off the check box of Active
3. Apply the changes
4. Run proutil idxbuild specifying only the name of the newly created indexes