In my tests, SIMILAR TO never uses an index.

Of course, you can force an index for the table with the clause ORDER BY

Greetings.

Walter.

On Fri, May 10, 2013 at 8:55 AM, Parzival <parzival1969@...> wrote:

> **
>
>
> Hello all,
>
> I could note find an information on that subject so far: Is there a way
> that
> SIMILAR TO uses an index? I did not see it so far:
>
> select * from bau2org where ORGANISATIONSEINHEIT SIMILAR TO '01%' - Does
> not
>
> select * from bau2org where ORGANISATIONSEINHEIT LIKE '01%' - uses index
>
> Motivation: SIMILAR TO would allow more complex queries than like.
>
> Thanks
>
> Niko
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]