Yes, I agree with the design problem. Many of these apps that we have
need to be re-written. Thanks for the info on the owa_match
performance.
Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1076564883.575249_at_yasure>...
> 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.
Received on Thu Feb 12 2004 - 08:14:51 CST
