At 07:11 PM 11/30/2004, GrumpyRain wrote:

>But how could that index help if your query went something like
>
>select name
>from employee
>where name like '%i'
>
>By inspecting 1 by 1, we know it is only Adrian and Martin, but the
>index can't help on this.

Actually, that wouldn't find any matches, though it would
match Bobbi or Terri.

Cheers,

Ann