Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> About Index B-Tree Problem!!
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