| Subject | Re: [SPAM] [firebird-support] select first 1 id from table order by id descending to slow |
|---|---|
| Author | Dennis McFall |
| Post date | 2006-05-23T15:26:28Z |
At 10:19 AM 5/23/2006, you wrote:
>hello./dm
>
>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?