Subject Re: [firebird-support] SQL - performance
Author Helen Borrie
At 01:00 PM 21/08/2004 +0200, Mr Bamsemums wrote:

> >
> > The second query has an expression for its search operand, ruling out use
> > of the index (for now...expression indices are coming...but the expression
> > index would have to exist).
>On the other hand, a substring(1, x) could be converted to a
>STARTING WITH as well :-)
>No need for expression indices there.

Could be converted to choc-dipped candy, too...but isn't.