Sorry about the size of this message!, it covers several optimisation
areas.
Yes we are talking about a limited situation of ORDER BY (that does not
match the GROUP BY order) plus LIMIT, but one that is easy to identify.
It also has the advantage that the number to be LIMITed will 9 times out
of
HACKERS: see the end of this message about a possible optimisation for
ORDER BY+LIMIT cases (the normal use of LIMIT?)
Adam wrote:
>
> I help run a job database and have a table of search records. I want
> a query that will return the top 10 jobs by search frequency. I'm
> familiar with ORDER
