Re: About Index B-Tree Problem!!

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 6 Jun 1999 17:32:54 +0200
Message-ID: <928683086.22496.0.pluto.d4ee154e@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

Roger wrote in message <7jdvue$43c_at_netnews.hinet.net>...
>Dear Sir:
> I had a problem about index b-tree.
> I have a table which have a column is a sequence number
>(000000001,000000002,000000003,000000004,....). I want to add
>a index on this column for this table. How does Oracle handle
>such data in index B-Tree. I mean this B-Tree may be very inefficiency:
>
> 000000001
> |
> 000000002
> |
> 000000003
> |
> 000000004 (search index item like a full scan)
>
> Does Oracle 7.3 have any index option to improve B-tree search
>performance
>for such data ???
>
>Thanks a lot!!
>
>Roger Li (pyli_at_tsmc.com.tw)
>
>
Received on Sun Jun 06 1999 - 10:32:54 CDT