MySQL Forums
Forum List  »  Optimizer & Parser

Re: GROUP BY ,ORDER BY optimization help
Posted by: Rick James
Date: October 07, 2011 11:54AM

First, does "GROUP BY order" give you the 'right' answer?
Based on the SELECT, I would expect you to need
GROUP BY g.id, g.name, g.playcount, g.rating, g.desc, g.nameid

I see no obvious reason for using LEFT; maybe use plain JOIN?

The first of these is redundant, and can be DROPped:
> KEY `active` (`active`,`unhacked`),
> KEY `active_2` (`active`,`unhacked`,`order`),
> KEY `active_3` (`active`,`unhacked`,`playcount`),

> int(25)
The 25 is nonsense. INT has a range of plus/minus 2 billion, regardless of the number after it.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: GROUP BY ,ORDER BY optimization help
1245
October 07, 2011 11:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.