[V4MD] Index by Words (newbie question)

[Ruslan Zasukhin]

On 10/4/04 12:48 AM, "Daniel Crowder" <daniel at monumental-i.com> wrote:

Hi Daniel,

> 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?

You should do query of kind

    WHERE left( textFld, 3 ) = 'abc'

This will use index


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------