Kbase P16878: What is the best utility to use to reactivate an index?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/08/2009 |
|
Status: Verified
GOAL:
What is the best utility to use to reactivate an index?
GOAL:
Why idxbuild is the best utility to reactivate an index.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
The best way to reactivate an index from a performance stand point would be idxbuild. The reason, is because an index tree built by idxbuild is better compacted and balanced than a tree fixed using idxfix. Compacted index trees also improve performance. If there are only a few records, then this wouldn't be too significant.
As of 10.1A a new option was added for proutil that allows you activate indexes online. The new option is: proutil -C idxactivate. For additional information on this option to proutil see solution: P149661, "What is idxactivate?"