Re: Excessive Logical and Physical I/O

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 27 Mar 2004 05:04:39 +1100
Message-ID: <406470c9$0$26646$afc38c87@news.optusnet.com.au>

"Holger Baer" <holger.baer_at_science-computing.de> wrote in message news:c412ul$1a8$1_at_news.BelWue.DE...
> Howard J. Rogers wrote:
> > "Holger Baer" <holger.baer_at_science-computing.de> wrote in message
> > news:c40rqb$kjp$1_at_news.BelWue.DE...
> >
> >>Brian Peasland wrote:
> >>
> >>>>>If I need to be corrected, then I need to be corrected.
> >>>>
> >>>>Oh well, in that case... do something about that paper showing 50%
> >>>>improvements in speed because of an index rebuild!!! ;-)
> >>>
> >>>
> >>>I was waiting for someone to take me to task for that paper....I wrote
> >>>that paper many moons ago, so the information is dated. And I don't go
> >>>back and update my papers every time I learn something new. I had been
> >>>meaning to add some more information to that paper, but just havn't
> >>>gotten around to it yet. Your comments prompted me into action today.
If
> >>>you go to my website (http://www.peasland.net), you will see that I did
> >>>add an addendum to that white paper.
> >>>
> >>
> >>However, Howard let you get away with this:
> >>
> >><quote>
> >>Contrary to some widely accepted beliefs, indexes in Oracle are not
> >
> > self-balancing. After a table
> >
> >>experiences a large number of inserts, updates, or deletes, the index
can
> >
> > become unbalanced and
> >
> >>fragmented
> >></quote>
> >>
> >>Lucky bastard ;-)
> >>
> >>Cheers
> >>Holger
> >
> >
> >
> > ;-o Am I really that bad??

>

> Ahem, er ... no
> It's just that some people can't stand being corrected. Especially when
they
> tend to get much things wrong or at least inaccurate. You'd never let them
> get away with such a phrase. (Hey, I'm not mentioning a single name
either) ;-)

Ah, but you see... the difference is that Brian doesn't proclaim himself to be one of the world's leading Oracle experts.

That makes all the difference in the world, actually.

Regards
HJR Received on Fri Mar 26 2004 - 12:04:39 CST