Subject Re: [firebird-support] MAX() and index
Author Jesus Garcia

El 7/9/2015, a las 15:00, Tim Ward tdw@... [firebird-support] <> escribió:


Please can someone explain to me, again, why

select Max(MYCOL) from MYTAB

doesn't use the primary key


I think you need to have a descending index in order to use it for select max.

If you select min instead of max, the pk index will be used