News for hackers. Stuff that matters.
Re:On “order by” optimization by goldenkey on Friday July 31, 2015 @07:21PM (#9985091)
Its usually better to be explicit and use aggregates like MAX or MIN instead of a LIMIT of 1.
Re:On “order by” optimization by degenerate on Friday July 31, 2015 @10:38PM (#9985657)
Can you elaborate on that with an example? I can't imagine when running MAX() or MIN() could be better than a static digit, so an example would help me understand your comment!
Re:On “order by” optimization by crishoj on Saturday August 01, 2015 @01:06AM (#9986029)
As in SELECT MAX(a), c, d FROM t WHERE b=x?

MySQL will return a random c and d, not necessarily the c and d from the row with maximum a...

Re:On “order by” optimization by acqq on Saturday August 01, 2015 @05:04AM (#9986424)
Goldenkey actually posted

SELECT c,d FROM t WHERE a=(SELECT MAX(a) WHERE b=X from t)

But that post got flagged because he also gave his opinion on the level of understanding the article writer has. The query you posted is actually the one by the article writer.

Re:On “order by” optimization by crishoj on Saturday August 01, 2015 @07:21PM (#9989102)
I see. Thanks.