Kbase P23568: Why idxfix plus idxcompact can almost replace idxbuild?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Why idxfix plus idxcompact can almost replace idxbuild?
FIX:
Having run idxfix option 3, all the index entries are as correct as if they were just built.
Having run idxcompact, the number of index blocks has been reduced and the index utilization (% Util) will be increased.
Having run idxbuild you have all the index entries correct and you have the maximal index utilization.
The advantage of idxfix and idxcompact are that they can be run on-line. An idxbuild can only be done off-line.