Re: Index maintenance...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Wed, 5 May 2004 18:32:40 +0200
Message-ID: <c7b4v8$mfp$1@nntp.fujitsu-siemens.com>

"Marc Blum" <blum_at_marcblum.de> schrieb im Newsbeitrag news:2p3i90thlqf8s1apur3fgegjo2113s4rmj_at_4ax.com...
> On Wed, 5 May 2004 11:22:04 +0200, "Volker Hetzer" <volker.hetzer_at_ieee.org>
> wrote:
>
> >Hi!
> >We've got a consultant (for a canned app) here who just hinted at a possible performance improvement
> >if one recreates the indexes after a big load.
>
> Possibly the consultant had in mind an unclear picture of this typical massload
> scenario:
>
> LOOP over all indexes
> set index to UNUSABLE
> END LOOP
>
> DO THE LOAD! yeah... APPEND it
>
> LOOP over all indexes
> rebuild index NOLOGGING COMPUTE STATISTICS bla
> END LOOP
>
> and forgot the first loop?

No, that wasn't it.
So far it we do not have any reproducible effect of the actions of that application. Looks like the dove-and-corn-effect to me.

Lots of Greetings!
Volker Received on Wed May 05 2004 - 11:32:40 CDT