Subject Re: Two queries - 1 good performance + 1 poor performance?
Author tomc7777777
--- In firebird-support@yahoogroups.com, Alexandre Benson Smith <iblist@...> wrote:
>

> How long does it take to run this:
> select cn.firstname,cn.lastname,cn.email1,cn.dateofbirth,cn.name
> person cn
> where (upper(cn.name) starting with 'S')


Almost instantaneous.
Tom