| Subject | Re: [firebird-support] max() on primary key very slow |
|---|---|
| Author | Matthias Hanft |
| Post date | 2012-02-03T18:10:44Z |
ruchbah@... wrote:
Matt
>As far as I know, you need a DESC index for MAX queries.
> I have a table with the column 'ID' as BIGINT unique primary key.
> select max(ID) from T
> So Firebird seems to do plan a full table scan. (Hallo, anyone at home?
> I have an unique index on that column ;-) )
Matt