In case you have your own slow SQL query, you can optimize it automatically here.
For the query above, the following recommendations will be helpful as part of the SQL tuning process.
You'll find 3 sections below:
ALTER TABLE `rel_score` ADD INDEX `rel_score_idx_score_date` (`score_date`); ALTER TABLE `rel_score` ADD INDEX `rel_score_idx_user_id_rel_score` (`user_id`,`rel_score`);
SELECT rel_score.user_id, max(rel_score.rel_score) AS max_rel_score FROM rel_score WHERE rel_score.score_date BETWEEN '2012-01-01' AND '2012-06-30' GROUP BY rel_score.user_id ORDER BY max_rel_score DESC