Re: Oracle 7.3.4 - Regular Index Rebuild - Necessary ?

"Luis Correia" <llcorreia_at_yahoo.com> wrote in news:RvKdnWqBHLpGgBffRVn-oQ_at_rogers.com:

> hello...
>
> i have encountered several sources on the net stating that
> regularly rebuilding an index yields no "measurable" improvement
> in performance...
>
> if so, is this true of oracle 7.3.4
>
> to be fair, i have also encountered sources stating that performance
> does improve..
> in any case, my question is still: does this hold true for oracle
> 7.3.4
>
>

It depends upon the state of the index before rebuilding. It can help in some cases.
It won't improve things in other cases.
There is NO hard and fast way to predict the results. Received on Tue May 17 2005 - 21:03:18 CDT