performance question

From: Craig Taylor <craigtaylor2_at_home.com>
Date: Tue, 20 Feb 2001 22:00:55 GMT
Message-ID: <rOBk6.47706$HG.11042620@news4.rdc1.on.home.com>

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 Tue Feb 20 2001 - 16:00:55 CST