Re: Index management

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 11 May 2004 09:30:05 +1000
Message-ID: <40a01071$0$24919$afc38c87@news.optusnet.com.au>

Joel Garry wrote:

> This one popped up in my email:
>
> http://searchoracle.techtarget.com/tip/0,289483,sid41_gci960148,00.html?track=NL-94&ad=482086
>
> For those who don't want to register there, it basically does an
> analyse index validate structure on all non-sys% indices, then builds
> a rebuild command if > 20% of the leafs are deleted.
>
> Interested in people's opinions on it, rants about arbitrary
> percentages always appreciated.

It's been done to death here, surely. It is irrelvant if deleted leaf rows exceeds any particular number. The issue is whether it *stays* that way.

HJR Received on Mon May 10 2004 - 18:30:05 CDT