Re: index blocks read one at a time or is this old info? (Sorta a myth?)

From: Pablo Sanchez <pablo_at_dev.null>
Date: Fri, 17 May 2002 15:36:19 -0600
Message-ID: <3ce575f0$1_4@news.teranews.com>

"D.Y." <dyou98_at_aol.com> wrote in message news:f369a0eb.0205171333.6d148c73_at_posting.google.com...
>
> > 3) If 1) again, any plans to start storing the data sorted so we
can
> > do "index_multiblock_read"s? I realize that there's a hit on
changes
> > to the b-tree because we'd have to rebalance the tree and possibly
> > affect many DB blocks.
>
> Forcing index blocks to be physically sorted will create too much
overhead
> for DMLs. I hope Oracle won't do that.

There's a definite trade-off ... it seems that we still do point I/O's based on another post within the 'Oracle Myths' thread.

--
Pablo Sanchez, High-Performance Database Engineering
mailto:pablo_at_hpdbe.com
http://www.hpdbe.com
Available for short-term and long-term contracts

Received on Fri May 17 2002 - 16:36:19 CDT