Subject Re: INDEXes for a Query
Author peter_jacobi.rm
--- In, "Svein Erling" wrote:
> prepare time the optimizer cannot know whether :Parametername will
> start with a constant or '%'. That's why I prefer using UPPER_WPName
> STARTING 'OEDER'. Possibly UPPER(W.WpName) could use an index if you
> use a case insensitive collation, but I've never used a case
> insensitive collation myself.

For the foreseeable future, that's too much AI questioned for.

But any multi-level collation (like the de_DE etc) can be used
in combination with BETWEEN for a similiar effect.

BETWEEN LOWER(WpName) and UPPER(WpName) || "ZZ"

Peter Jacobi