Re: About Index B-Tree Problem!!

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 9 Jun 1999 20:24:31 +0100
Message-ID: <928958318.24911.0.nnrp-07.9e984b29@news.demon.co.uk>

That is correct, but the balancing refers to the fact that the height of the tree is uniform (+/- 1 level) across the whole tree.

There are some circumstances where the amount of data per leaf varies greatly across the b-tree.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Matthew McPeak wrote in message ...
>
>I was under the impression that Oracle always keeps its indexes balanced,
>even after inserts and deletes. Is this not the case?
Received on Wed Jun 09 1999 - 14:24:31 CDT