Re: Binary or Hash search in plsql table

Would it make sense to use an object-type table instead of a pl/sql type table.

Then you could cast the 100 rows into a
relational table and use it in the FROM clause of your cursor query with a join to the
rest of the query.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


Sunil wrote in message ...


>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.

>

>

>