Re: Proving or Debunking the need for rebuilding

From: Ben <balvey_at_comcast.net>
Date: 10 Nov 2006 04:55:22 -0800
Message-ID: <1163163322.919517.255160@e3g2000cwe.googlegroups.com>

hpuxrac wrote:
> hasta_l3_at_hotmail.com wrote:
> > I checked exactly this last month. In retrospect, I would use
> > this methodology :
> >
> > 1. Setup a load test environment duplicating system activity
> > 2. Let the system run for 15 days, without index rebuild.
> > 3. Time a small representative set of transactions, including
> > - Most common querying user action(s)
> > - Most common updating user action(s)
> > - Nightly batch jobs
> > 4. Rebuild all indexes
> > 5. Time again
> > 6. Run one week with nightly rebuilds
> > 7. Time again
> > 8. Believe your data
>
> What conclusions did you reach based on your approach?

This is all very good information. I won't be doing nightly rebuilds though. This is just a one time ( hopefully ) thing and I wanted to make sure that I wouldn't be causing any harm.

Thanks for all the replies thus far, if anyone has any other info they'd like to share post it up. Received on Fri Nov 10 2006 - 06:55:22 CST