Re: [Q]: Indexes with LIKE clause

neil_at_ms.uky.edu (Neil Greene) writes:

>What ill effects does the use of a LIKE clause have with respect to
>index performance, if any??
>
>-- Neil

It depends on how you use a like and how your indexes are created. If you are performing a like on an indexed database field, placing a % on the end or in the middle will allow partial use of the index. Placing a % on the front will cause a full table sacn.

EG:  where emp.name LIKE 'BRO%' will use index
     where emp.name LIKE '%OWN' will not use index
     where emp.name LIKE 'BR%N' will use index to qualify the BR, then scan

Darin Brown
Oracle Commercial Consulting Received on Tue Nov 08 1994 - 17:50:55 CET