Like operator

[Ruslan Zasukhin]

On 8/5/07 1:43 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

> I would like to know if the "LIKE" operator in sql uses the fields
> index to retrieve the records.

Yes if this have sense

> For this field I checked both indexed and indexed by word.

So you have IndexByWords index.
 
> I remember from pre-Valentina days that Like operator always did
> sequential search?

Yes.

Now it CAN use indexes if it is possible for operation of LIKE.
Mainly only if you do:
        LIKE "ABC%"

I.e. In fact you do search START WITH

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