Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How are INDEXES BALANCED?

Re: How are INDEXES BALANCED?

From: Steve Haynes <steve_at_rwx777.demon.co.uk>
Date: 1997/09/11
Message-ID: <gR4hYIAAbBG0Ews+@rwx777.demon.co.uk>#1/1

In article <01bcbec5$a33ab660$65a09384_at_dennislap>, Dennis Taylor <no_spam_dammit_at_ipipeline.net> writes
>
>Ardley Tschetter <ardley_at_interaccess.com> wrote in article
><01bcbe1a$df80d240$829794cc_at_albloo>...
>> I need to know if an index is not balanced, how do I get it balanced or
 is
>> it done automatically? For example, when I enter an order number to an
>> order entry system and the numbers are sequentially numbered, are the
>> records added to the b-tree in one straight line to the tree?
>>
>
>The short answer is that Oracle automatically balances an index (or so I've
>been told). The logic for doing so is straightforward enough that, if they
>didn't, you'd have to go over and slap Larry Ellison upside the head.
>

 I think there's a queue....

-- 
"The floggings will continue until morale improves."
Received on Thu Sep 11 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US