On Thu, Oct 09, 2003 at 17:44:46 -0700,
Dror Matalon <dror(at)zapatec(dot)com> wrote:
>
> How is doing order by limit 1 faster than doing max()? Seems like the
> optimizer will need to sort or scan the data set either way. That part
> didn't actually make a difference in my specific case.
max() will never be evaluated by using an index to find the greatest value.
So in many cases using order by and limit 1 is faster.