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 -> About Index B-Tree Problem!!

About Index B-Tree Problem!!

From: Roger <pyli_at_tsmc.com.tw>
Date: Sun, 6 Jun 1999 22:21:41 +0800
Message-ID: <7jdvue$43c@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 - 09:21:41 CDT

Original text of this message

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