RE index rebuilds

[Kenneth Brody]

On 6/29/2011 10:34 AM, Richard Kreiss wrote:
> 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.

Suddenly, or a little bit at a time?

> 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?

I believe that, using a number that is "too large", will only result in more 
memory being used than is necessary.  I don't recall any other downside.

-- 
Kenneth Brody