Given one inner join query and one outer join query that both produce the same results, which of the following statements is true?
A.
Inner joins are usually faster, use less memory and should be used instead of outer joins.
B.
Outer joins are usually faster, use less memory and should be used instead of inner joins.
C.
Inner and outer joins are running at the same speed and take the same amount of memory.
Explanation:
Outer Joins read all of 1 table and then look for matches in the 2nd table – inner joins can let MySQL optimize which table to start with.