On Wed, Jun 22, 2011 at 10:04:11AM -0500, Dan McGee wrote:
> We were doing some silly things here with an "ORDER BY Name, CategoryID"
> clause, due to the fact that Name is unique, and thus any additional
> ordering after Name will have no effect. Of course, the dumb as a box of
> rocks MySQL query
We were doing some silly things here with an "ORDER BY Name, CategoryID"
clause, due to the fact that Name is unique, and thus any additional
ordering after Name will have no effect. Of course, the dumb as a box of
rocks MySQL query optimizer doesn't realize this, leading to full table
scans every