[V4MD] Index by Words (newbie question)

Daniel Crowder daniel at monumental-i.com
Sun Oct 3 17:48:22 CDT 2004


I'm looking for ways to speed-up a product search.

I currently am using LIKE to check to see if certain key-words exist in 
a field called TEXT. Reading over the documentation it says that using 
LIKE in a query does not take advantage of a field's index. I am now 
confused as to how to take advantage of the INDEX BY WORDS feature. How 
do I perform the fastest query of a text field that is using INDEX BY 
WORDS without using LIKE?

Any suggestions appreciated!

- Daniel



More information about the Valentina mailing list