Like operator

[Bart Pietercil]

Hi Ruslan,

that's pretty much what I suspected.
I suppose this is the same for RegEx search
However may I recommend that the WIKI page where the like operator is  
explained be updated with this information.

Can I then also conclude the inverse?
Is it then better not to index the field if I will only search it % 
like%, or does it not mather (besides the space on the server)


Now go back to work and get me that .10 ready :-)

Bart


On 8-mei-07, at 17:58, Ruslan Zasukhin wrote:

> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina