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 -> Binary or Hash search in plsql table

Binary or Hash search in plsql table

From: Sunil <sunil_franklin_at_hotmail.com>
Date: Wed, 10 Apr 2002 15:24:54 +0530
Message-ID: <z%Ts8.11$U23.41@news.oracle.com>


I have a plsql table ( table of number index by binary integer) which has some values ( ~ 100 ).
Now I need to search through this plsql table for all of 10,000 rows from a database table (selected in a cursor).
Right now there is a linear search in place and I am looking at making it faster.
Because I am operating on a long column from the database table (for comparison) I cannot use bulk/sql operations.

Can any of the experts out there suggest a better way than the linear search. Or any built in function in pl/sql which will make my lookup faster ?

I am running on Oracle 9i.

--
Sunil.
Received on Wed Apr 10 2002 - 04:54:54 CDT

Original text of this message

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