Re: Index maintenance...

From: Marc Blum <blum_at_marcblum.de>
Date: Wed, 05 May 2004 18:02:55 +0200
Message-ID: <2p3i90thlqf8s1apur3fgegjo2113s4rmj@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?

--
Marc Blum
mailto:blumNOSPAM_at_marcblum.de
http://www.marcblum.de

Received on Wed May 05 2004 - 11:02:55 CDT