Re: interest of indexes ....

From: Stephen B <stephen.bell_at_cgi.ca>
Date: Mon, 17 Jun 2002 11:41:36 -0400
Message-ID: <tunP8.1193$Rf7.415726@news20.bellglobal.com>

Hi Fred,

No, I believe the wildcard operator will cause it not to use the index.

Steve

"Fred Burlaud" <fburlaud_at_com6.fr> wrote in message news:3D0DE076.20404_at_com6.fr...
> Hello,
>
>
> An index works for search of the complete string of the field but
> is it appropiated for the substring search too
>
> For ex. I would like to know if an index on phone field is appropriated
> in this case
>
> SELECT * From Contact WHERE phone like '%0867%';
>
> Thanks
> Fred
>
Received on Mon Jun 17 2002 - 10:41:36 CDT