Subject | Re: [firebird-support] SQL - performance |
---|---|
Author | Helen Borrie |
Post date | 2004-08-21T11:27:58Z |
At 01:00 PM 21/08/2004 +0200, Mr Bamsemums wrote:
./heLen
> >Could be converted to choc-dipped candy, too...but isn't.
> > 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.
./heLen