Kbase P101715: Is idxbuild necessary after a dump and load?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Is idxbuild necessary after a dump and load?
GOAL:
Must idxbuild been run after a data load?
FIX:
No, if an Ascii load from within the Data Dictionary is run.
No, if a Binary load with the option "build indexes" introduced in 9.1B, as per the following syntax, is run.
proutil <db> -C load <file> build indexes [-TB <blocksize>] [-TM <#blocks] [-T <dir>] [-SS <srtfile>]
Yes, in other cases:
. Binary load without the option "build indexes"
. Bulkload, as per the command of syntax:
proutil <db> [-yy n] -C bulkload <fd_file> [-B n]