Re: Search Problem

This sounds like a good application for USER_DATASTORE -- you write a function that concatenates the relevant columns and feeds the results to interMedia during indexing of a single column. The concatenated text doesn't need to exist anywhere in the table. (I use a similar technique with FILE_DATASTORE, storing massaged text in dummy files that get thrown away after indexing is finished.)

John

On Sat, 24 Nov 2001 15:30:43 +1100, "Matt Morton-Allen" <matt_at_phoroneus.com> wrote:

>Hi,
>I am trying to create a web based search of a simple table of a telephone
>directory. The search is a standard web search where you enter the search
>term and get the results that match. My problem is that cannot figure out
>how to search many small fields (20) for the one term without a massively
>inefficient use of OR's and LIKEs '%text%'.
>
>I looked at the interMedia stuff which seems okay but seems to require an
>index for each field. Since some of the fields are quite small (as little as
>20 characters) this seems like overkill and doesn't really solve the OR
>problem anyway.
>
>So any suggestions on where to look?
>
>Matt.
>

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/