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