Re: How are INDEXES BALANCED?

I was taught that B trees (and B+ trees, which I think Oracle uses) are self-balancing. The tree should always be balanced, regardless of the sequence in which you load the data.

Ardley Tschetter wrote:
>
> 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 views expressed here are mine and do not reflect the official
position of my employer or the organization through which the 
Internet was accessed.