Please Explain - Index by Word

[Ruslan Zasukhin]

On 7/27/14, 2:22 AM, "Kay C Lan" <lan.kc.macmail at gmail.com> wrote:

> On Sat, Jul 26, 2014 at 7:41 PM, Ruslan Zasukhin
> <ruslan_zasukhin at valentina-db.com> wrote:
>> 
>> Index By Words is good choice for big strings,
>> For example 'Body of email'.
>> 
>> 
>> IndexByWords is not so powerful as Full Text search,
>> we do not have it. But usually this is enough.
>> 
> OK, so Index By Words is good for big strings when I'll frequently be
> searching for single words. Do not use if searches will ALWAYS be
> multi-word. And if I need to do both then = for single words, LIKE for
> multi-word. Got it. Thanks for taking the time to explain.

And you can create TWO indexes for this column.
One normal, second - by words

You can use for this Table Method (aka Calculated Field).


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]