Re: more index questions

From: <bplegend_at_yahoo.com>
Date: 20 Jun 2001 20:14:24 -0700
Message-ID: <5d0822ae.0106201914.5ca8894@posting.google.com>

You rebuild an index when your index has about 5 to 10% fragmented, a number of chained/migrated rows and after a large load of data.

You can look at your 'analyze index' output and decide whether the index needs a rebuild.

benny

u518615722_at_spawnkill.ip-mobilphone.net wrote in message news:<l.993045842.1372711181@[198.138.198.252]>...
> After the analyze index, how do you know whether an index needs
> to be rebuild? I check the DBA handbook, it only say after major
> data load, you need to rebuild an index. Is there more quatative
> way to measure an index's usefulness?
>
> Thanks
Received on Wed Jun 20 2001 - 22:14:24 CDT