A RIGHT JOIN would potentially return more results than an INNER JOIN.
I do not see how it could be, in the absolute, be faster.
How large were the tables and how did you do your testing? What platform
did you use and were you InnoDB or MyISAM?
From: Robert DiFalco [mailto:rdifalco@stripped]
Sent: Monday, March 20, 2006 5:12 PM
Subject: RIGHT JOIN better than INNER JOIN?
I apologize if this is a naive question but it appears through my
testing that a RIGHT JOIN may out perform an INNER JOIN in those cases
where they would produce identical result sets. i.e. there are no keys
in the left table that do not exist in the right table.
Is this true? If so, it this peculiar to MySQL or would this be true
with almost all database servers? i.e. Oracle, DB2, MSSQL, etc.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql