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 ...
Subject
Views
Written By
Posted
3663
February 15, 2008 06:52PM
Re: Help Optimizing Query
2378
February 17, 2008 09:13PM
2324
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.