Hallo,

SQL databases are always in for a surprise about performance of simple
statements.

I have a table with the column 'ID' as BIGINT unique primary key.

The table has about 4000000 entries, the ID counts up without gaps.

A simple

select max(ID) from T

takes about 14 seconds complete.

Execution plan:

PLAN (T NATURAL)

So Firebird seems to do plan a full table scan. (Hallo, anyone at home?
I have an unique index on that column ;-) )

Some databases can do so much better here: The same statement on a 100%
identical Derby database completes immediately, as does on an Oracle 10g XE.

Do I miss something ? Any suggestions ?

Best regards

Marc