> El 7/9/2015, a las 15:00, Tim Ward [email protected] [firebird-support] > <[email protected]> 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 >
