"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 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.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
http://www.niall.litchfield.dial.pipex.com/
Received on Wed May 05 2004 - 04:51:16 CDT
