Re: Suggestions for first exam ...

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:bl61qb$mec$1$8302bc10_at_news.demon.co.uk... --snip--
> "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> news:rGgdb.126227$bo1.111770_at_news-server.bigpond.net.au...
> >
> > Coincidently again (first the last time), I've noticed a new article
 by
> > Jonathan Lewis at dbazine which nicely describes why the unbalanced
 Oracle
> > index is myth of utter crappy proportions (perhaps my complaint had
 an
> > effect ?)
> >
>
> I wrote it because I came across yet another bloody
> "expert" explaining that sequences cause Oracle's
> indexes to get extremely deep on the right so that
> indexes need to be rebuilt.
>
> There is another article coming out soon (I think)
> that points out why it is usually a waste of time
> to rebuild indexes at all - and gives an example
> showing how a regular rebuild can make things
> worse.

The article by Mike Hordila is published in oracle own site: http://www.oracle.com/oramag/webcolumns/2001/index.html?auto_index.html

Now how does Oracle itself let this guy publish (in their own website) a totally untrue article showing the ;) fascinating diagram of what unbalanced indexes look like.

:)
In fact you should see his site http://members.rogers.com/mhordila/ he's got loads of useless and myth creating articles out there.

Anurag Received on Mon Sep 29 2003 - 01:15:03 CDT