Re: Joint index including MAX() ?

you can also try :

select val FROM table ORDER BY val DESC LIMIT 1;

which usually is much quicker.