On Thu, Oct 09, 2003 at 17:44:46 -0700,
Dror Matalon <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
