Search Method without %these% or ConText?

Hi,

I have a web application (cgi written in perl) that searches thru an oracle database, two of the fields searched are keyword types, where I would like the functionality of doing a double percent pattern match. e.g.

SELECT something, anything, everything
FROM sometable WHERE something = 'exact', AND anything like '%close but not exact%'

I was told by DBAs that this is unacceptable because it does a full table scan. We were going to use ConText searches for these fields but apparently the overhead from that is also high.

Does anynone have any experience or suggestions? Some 3rd party product, or a neat trick?

Thanks,

cansubaykan_at_netscape.net

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Apr 25 2000 - 00:00:00 CEST