Re: Proving or Debunking the need for rebuilding

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 10 Nov 2006 03:48:57 -0800
Message-ID: <1163159337.172453.305950@b28g2000cwb.googlegroups.com>

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? Received on Fri Nov 10 2006 - 05:48:57 CST