Subject Re: [firebird-support] Usage of expression index - Known limitation?
Author Adriano dos Santos Fernandes
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.