Re: performance question

If you are using Oracle8i, turn on Intermedia - the Oracle built in text search engine. It's fully documented and web compatible. (Prior to Oracle8i, look for Context Option)

/Hans

Craig Taylor wrote:

> Hi,
>
> I really appreciate any insight anyone can offer me.
>
> I am about to set up a small search engine for my shopping site. I have just
> over 1100 products now, but I am expecting much more (knock on wood).
>
> I want to use indexing to speed things up. The tables for the search will
> not be updated (insert deletes etc).
>
> My question has to do with the whether to break the product description
> field down into individual words and store them as new fields (and index
> them), or to use a "LIKE" query to search the description field for the
> word. Also, can I use indexing with a "LIKE".
>
> Thanks again,
>
> Craig
  Received on Fri Apr 27 2001 - 08:48:57 CEST