MySQL Forums
Forum List  »  Optimizer & Parser

Re: Help Optimizing Query
Posted by: Ryan Lowe
Date: February 17, 2008 09:13PM

1) users.id and scores.user_id should be the same datatype
2) Have you tried re-indexing the table(s) and re-running explain? Adding a compound index on scores (user_id, score) would surely help, but perhaps not be the best use of memory ...

Options: ReplyQuote


Subject
Views
Written By
Posted
3584
February 15, 2008 06:52PM
Re: Help Optimizing Query
2336
February 17, 2008 09:13PM
2283
e h
February 21, 2008 07:50PM


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.