Re: EXPLAIN shows optimized query

[Mahesh Kumar]

explain SELECT * FROM `questions` inner join choices on questions.question_id = choices.FK_question_id

1 SIMPLE questions NULL ALL PRIMARY NULL NULL NULL 2 100.00 NULL
1 SIMPLE choices NULL ref FK_question_id FK_question_id 4 dummy_quiz.questions.question_id 2 100.00 Using index condition

Here choices table is myisam
When i convert it to innodb

The same explain produces the following output.


1 SIMPLE questions NULL ALL PRIMARY NULL NULL NULL 2 100.00 NULL
1 SIMPLE choices NULL ALL FK_question_id NULL NULL NULL 5 20.00 Using where; Using join buffer (Block Nested Loop)

Above the two, which one will produce faster results?
Which one produce slower results? Why?
Do i need to design every table with different engines?
Please help