|Subject||Re: [SPAM] [firebird-support] select first 1 id from table order by id descending to slow|
At 10:19 AM 5/23/2006, you wrote:
>i'm having the following problem:
>i found out that
>"select first 1 id from table order by id descending" (in order to
>select the last record) is *WAY* slower than "select first 1 id from
>table order by id ascending" (in order to select the first)
>Do you have a descending index on that field?