Home -> Usenet -> comp.databases.oracle -> PL/SQL Tables (in memory) Performance? ver 8

PL/SQL Tables (in memory) Performance? ver 8

From: McAllister <lmcallister_at_bfsec.bt.co.uk>
Date: 1999/03/24
Message-ID: <7dahr2$2us$1_at_pheidippides.axion.bt.co.uk>#1/1 






Hi,



Here is a technical qus about PL/SQL tables - memory structures.



You can create a PL/SQL table with indexes 1, 4, -5, 10, 9876 etc.



We need to be able to access data held at those indexes  frequently (and
quickly!)



Do you know how Oracle stores these indexes (and data) internally. Does it
create a binary search index on the fly, such that it can find the index
quickly? or does it search sequentially through each index (which would be
too slow!)



Please reply by email!




Thanks,



Liam.
Received on Wed Mar 24 1999 - 00:00:00 CET












Original text of this message