query running soo slow
Posted: Sat Dec 08, 2007 9:41 pm
Ok, I have the following query
And it's running incredibly slow, If I remove the inner join on settings, it flys... but for some reason when I add that one join it goes incredibly slow, too slow..
I have indexes on
Settings.quiz_id
User_log.user_id
User_log.quiz_id
Answers.quiz_id
Any ideas if there is any specific I should be doing or looking out for?
Code: Select all
SELECT DISTINCT
user_log.quiz_id AS quiz_id,
quizes.name AS name,
quizes.canvas_url AS canvas_url,
answers.answer_profile AS answer,
answers.image_guid,
answers.description,
user_log.answer_id,
settings.show_profile,
settings.show_image
FROM
user_log
Inner Join quizes ON quizes.id = user_log.quiz_id
Inner Join answers ON answers.id = user_log.answer_id
Inner Join settings ON answers.quiz_id = settings.quiz_id
WHERE user_log.user_id = '123456'
GROUP BY quiz_id
ORDER BY user_log.created_dt asc
And it's running incredibly slow, If I remove the inner join on settings, it flys... but for some reason when I add that one join it goes incredibly slow, too slow..
I have indexes on
Settings.quiz_id
User_log.user_id
User_log.quiz_id
Answers.quiz_id
Any ideas if there is any specific I should be doing or looking out for?