At 11:14 PM 24/10/2009, you wrote:

>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?

Missing a DESCENDING index on ID?

./heLen