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".