Re: analyze index

From: <nelsona_at_my-dejanews.com>
Date: Wed, 04 Nov 1998 17:43:41 GMT
Message-ID: <71q3od$aio$1@nnrp1.dejanews.com>

In article <71peme$u9m$1_at_newsreader4.core.theplanet.net>, "B.Sc Yassir Khogaly" <yassir_at_khogaly.freeserve.co.uk> wrote:
> This is Oracle Corporation's Documentation for ANALYZE Command..
>
> Regards
>
>

[BIG SNIP] Er.... OK, right.

However, to ANSWER the original question (succinctly):

As a quick "rule of thumb", there are 2 columns in sys.index_stats to look at. They are HEIGHT and DEL_LF_ROWS.

Typically, if HEIGHT is >= 3, time to rebuild the index. If the number of DEL_LF_ROWS is high relative to the number of rows in the table for the index, time to rebuild the index.

HTH -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 04 1998 - 11:43:41 CST