Re: Binary or Hash search in plsql table

Sunil wrote:
>
> The pl/sql table holds varchar2 values.
>
> The cursor returns a long column from a database table.
>
> It is a substring match.
>
> Thanks,
> Sunil.
>
> "Jonathan Lewis" >
> > Just to clarify the situation -
> >
> > The pl/sql table holds about 100 'long' values.
> >
> > The cursor returns a long column from
> > about 10,000 rows, and you want to match
> > these up against the table.
> >
> > Is this correct ?
> > If so, is it an exact match, or a substring match
> > or what ?
> >
> > --
> > Jonathan Lewis

You could use dbms_utility to hash the long (after conversion to varchar2) into a numeric range and use this for the plsql table index

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."