FW: Indexing a file with 3,000,000 records FAST ?

[John Esak]

> In addition to trying PFBIXBUILD=2 you may want to try
> to build multiple indexes at the same time.
>
> Jeff Harrison
> jeffaharrison at yahoo.com

Have you actually tried this? Maybe you are just throwing this out as an
idea? I have tested this suggestion thoroughly on all sorts of machines.
Never once has building multiple indexes simultaneously beaten building the
rebuild of the same indexes one-at-a-time sequentially. Unlesa, you have
multiple CPU's in which case, there is some benefit... but not always. If
there is a very quiescent condition on the system and the first index build
grabs the first CPU and holds it pretty successfully for long periods of
time, the next build of an index startst on the 2nd CPU... then, sometimes,
I've seen some improvement. Otherwise, building sequentially has always
worked out as fastest "overall".

On a single CPU, with even a quiescent situation, I do not think building
more than one index at at ime will save any time at all. Only think this
because of long experimentation... but YMMV.

John Esak