Re: LIKE operator

Hi,

>SELECT ... FROM ... WHERE ... x like Y
>,where x is a contant, and Y an indexed column of a table in the FROM part.
>Will Oracle use its index to improve performances ?

I think it does if you concatenate the Y with a % as in: x like (Y || '%').

Good luck!

• Martin Jesterhoudt
• martinj(replace this by @)xs4all.nl

  ---