Re: About Index B-Tree Problem!!

Sybrand,

I was under the impression that Oracle always keeps its indexes balanced, even after inserts and deletes. Is this not the case?

• Matt

Sybrand Bakker wrote in message
<928683086.22496.0.pluto.d4ee154e_at_news.demon.nl>...
>The B in B-tree stands for Balanced.
>The B-tree will only get skewed, if the index is created on an empty table
>and the table is filled afterwards.
>In this case just recreate the index (alter index <index name> rebuild in
>Oracle 7.2 and higher) and there will be a balanced index again.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
Received on Tue Jun 08 1999 - 18:28:41 CDT