Leyne, Sean escreveu:

> This is a known limitation of the *LIKE operator*.
>
> {though I'm not sure this particular twist has been logged in the
> tracker}
>
> I tried the same statements with a "standard" index and they exhibited
> the same modes.
>

LIKE <constant not starting with wildcard> injects a STARTING <constant
substring before the wildcard> that cause the index to be used. As the
PLAN is choose at prepare time, I see no good way to LIKE <non constant>
to use indexes.


Adriano