Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7.3.4 - Regular Index Rebuild - Necessary ?

Re: Oracle 7.3.4 - Regular Index Rebuild - Necessary ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 17 May 2005 23:58:53 +0200
Message-ID: <b7qk81dr9tvqspihhfgagr95mlvgpbaoh4@4ax.com>


On Tue, 17 May 2005 12:37:52 -0400, "Luis Correia" <llcorreia_at_yahoo.com> wrote:

>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
>

As the index structure didn't change from 6.0: yes

--
Sybrand Bakker, Senior Oracle DBA
Received on Tue May 17 2005 - 16:58:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US