Re: Index maintenance...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Wed, 5 May 2004 13:04:04 +0200
Message-ID: <c7ahn4$k1m$1@nntp.fujitsu-siemens.com>

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> schrieb im Newsbeitrag news:4098b914$0$20516$ed9e5944_at_reading.news.pipex.net...
> "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message
> news:c7abns$lm2$1_at_nntp.fujitsu-siemens.com...
> > 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.
> > He said he noticed an improvement but didn't run any benchmarks. He used
> 8.1.something and 9.0.something.
> > We are using 9.2.0.4.
> > So, what's behind this?
> > Does this apply to us too?
>
> checkout www.dbzine.com/jlewis14.shtml for a nice clear discussion of index
> rebuilding

:%s/dbzine/dbazine/g

> or for a somewhat more thorough, but slower to read discussion
> with evidence http://www.actoug.org.au/Downloads/oracle_index_internals.pdf
> which Richard Foote pointed us to the other day. Your consultant *may* be
> correct but I wouldn't bet on it.

Will check it out.

Thanks a lot!
Volker Received on Wed May 05 2004 - 06:04:04 CDT