Subject Re: [IB-Architect] Query Optimiser
Author Dmitry Kuzmenko
Hello, Nando!

Nando Dessena wrote:

> select ... from ...
> where somefield like :param
> The index is ignored even if you put param = 'start%' (using starting
> [with] does solve the problem, of course).
> Just wondering if there's a way to optimize such cases.

I think no. Because optimizer creates plan during prepare, when no
parameter values are specified. And, parsing parameter values is too complex.
But, I don't know about

select ... from ...
where somefield like :param||'%'.

Of course, :param||'%' also can be computed only during execute, but...

Dmitry Kuzmenko, Epsylon Technologies.