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.