Re: Suggestions for first exam ...

Well I had to look at the diagram for myself. First, what do the colors mean? That was never quite explained. Second, when did branch blocks become "node blocks". From anyone's Data Structures class, all branch blocks and all leaf blocks are "nodes", as in nodes that are visited in preorder, inorder, or postorder traversals of a tree data structure. And that diagram showing particular leaf blocks that are on a completely different level than the other leaf blocks.......oh wow......

Cheers,
Brian

Anurag Varma wrote:
>
> "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
 

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"