MySQL Join Performance Differences

Question

if you compare all the Joins that we have in MySQL, which takes the shortest time to get executed... PLease let me know if the question holds grounds and that if I m right in asking this..

Answer 1

There is, for practical purposes, no difference in performance between two particular types of joines. Obviously the data and indexes involved will have an impact, but constructing an left or right, inner or outer join that involves the same data and the same indexes should not be measurably different.