Re: How many people here rebuid index regularly?

In article <RcudnXIKhJSqd5jaRVnyigA_at_bt.com>, jonathan_at_jlcomp.demon.co.uk says...
> Did you ever find time to work out which indexes were
> particularly relevant to the massive change in the batch
> job, and what the difference was between the slow and
> the fast runs ?
>
>
>

No, Jonathan, Unfortunatly I never investigated more as of today, for lack of time and because the system is working fine as is.

I certainly agree that only a few indexes actually benefit from rebuild, and rebuilding them all is overkill and detrimental to some extent.

On the other hand, rebuilding all indexes is quick - on my system -, had no observable side effects in routine work, and we dont have to carefully analyze and measure whether a freshly added index actually needs a rebuild. Received on Fri Oct 05 2007 - 10:58:55 CDT