Re: interest of indexes ....

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 17 Jun 2002 15:58:15 GMT
Message-ID: <3D0E0709.D13DDB59@exesolutions.com>

Fred Burlaud wrote:

> 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

No index can do what you are asking.

I would suggest that you go to http://technet.oracle.com and read up on what indexes are and how they work.

Daniel Morgan Received on Mon Jun 17 2002 - 10:58:15 CDT