> El 7/9/2015, a las 15:00, Tim Ward t...@telensa.com [firebird-support] > <firebird-support@yahoogroups.com> escribió: > > Please can someone explain to me, again, why > > select Max(MYCOL) from MYTAB > > doesn't use the primary key > > PLAN (MYTAB NATURAL) > 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 Jesus >