Hi,

I have one table into firebird (2.1.3) databse with structure:
ID - integer (keyfield)
NAME - varchar (indexed)
DESCRIPT - varchar
and about 3.000.000 records in it.

I don't want to say that Oracle Express Edition is better than FirebirdSQL but when I call

SELECT MAX(ID) FROM TABLE1

Oracle returns 3.005.101 for a 2 secounds
Firebird returns 3.005.101 for a 10min and 15 secounds on same machine

What is wrong with Firebird in my case?

Thanks in advanced...