Jakie indeksy? Opcje

[robos85]

Witam, zastanawiam się jakie nadać indeksy dla tabel dla takiego zapytania:

[SQL] pobierz, plaintext 
SELECT `q` . * , `qa`.`qa_id` , `qa`.`content` , `qa`.`date` AS `qa_date` , `f`.`id` AS `flag_id` 
FROM `exp_questions` AS `q` 
LEFT JOIN (
 
SELECT `id` AS `qa_id` , `question_id` AS `question_id` , `content` , `date` 
FROM `exp_questions_answers` 
WHERE `user_id` = '1'
ORDER BY `date` DESC 
LIMIT 1 
) AS `qa` ON q.id = qa.question_id
LEFT JOIN `exp_questions_answers_flags` AS `f` ON qa_id = f.answer_id
WHERE (
 
STATUS = '1'
)
AND (
min_experience <= '66'
)
[SQL] pobierz, plaintext 

[erix]

A co mówi EXPLAIN? (IMG:style_emoticons/default/winksmiley.jpg)

[robos85]

(IMG:http://img4.imageshack.us/img4/6414/explainq.jpg)
a tu struktura tabeli 'q'
(IMG:http://img641.imageshack.us/img641/5146/expquestions.jpg)

O indeksach czytałem trochę i chciałbym sprawdzić czy te co zrobiłem są OK

Ten post edytował robos85 12.02.2010, 15:36:49