[Firebird-test] select MAX() not used INDEXES to run

[Carlo P. <ca...@ug...>]

Hi,

I'm testing firebird with a table with 65000 records. When I try to:

select MAX(COD_VALUE) from TABLE_TEST;

The plan used by firebird is NATURAL. This is strange to me because I have a
index for field COD_VALUE. I had to implement a stored procedure + a
descending index for field COD_VALUE to get, more quickly, the max value for
COD_VALUE.

Know anyone about this? I'm wrong ?

-Carlo