Re: Alternative to the LIKE command

OakRogbak_erPine_at_yahoo.com Kill the 2 trees in email address to reply wrote:

> One of our developers is trying to figure out how to search a string
> for a partial match. In other words, if you had a table such as
>
> NAME (Varchar2) TIDS (varchar2)
> --------------- --------------
> Joe Black
> 123123,432432,324234,764565,4334534,344353,45715435,35338
> Ben Hur
> 123756,324342,8237482,975924,145238,2934283,2348248,23423
> Tom Thumb
> 872834,93124,873247,092243,23432,823472,29349,7502849
>
>
> Is there another way to rewrite
>
> select NAME from MYTABLE where TIDS like '%324234%';
>
> so that you get better performance, assuming a great number of rows?
> Can the owa_pattern.match be used here?
>
> Thanks.

I'm with Al. This looks like a design problem not a performance problem.

But be advised OWA_MATCH is very very slow.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)