Kbase P44670: Load of .df takes too long
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
SYMPTOM(s):
Load of .df takes too long
Many indexes added to existing large tables
CAUSE:
During the .df load, after the index is added, the index is being "built"
FIX:
1. Add the keyword INACTIVE to the indexes on large tables (see sample below).
2. Run idxbuild for these indexes, not forgetting the startup parameters
-TB 31 -TM 32
Sample showing where to add the keyword INACTIVE
ADD INDEX "idx" ON "Customer"
AREA "Info Area"
UNIQUE
INACTIVE
INDEX-FIELD "Cust-Num" ASCENDING
INDEX-FIELD "Balance" ASCENDING