Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Binary or Hash search in plsql table
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