RE index rebuilds

[Richard Kreiss]

One of my clients has a procedure the rebuilds auto indexes at night.

The procedure has gone from 45 minutes to about 2 1/2 hours.

One file has 6 auto index ranging in size from 11MB to 76Mb.

I am currently testing setting pfnumixbuild and pfnumixbuf.

Besides guessing at what values to use, is there a better way to decide what
values to use with each?

Richard Kreiss
GCC Consulting
rkreiss at gccconsulting.net