On Thu, Mar 12, 2009 at 8:41 AM, mos <mo...@fastmail.fm> wrote: > I have 3 tables that are 1:1 and will always have a row for a given > product,_code & date. If I want to join them together, is it going to be > faster to use an equi join or a left join, or does it matter? >
IIRC:With an inner join the optimizer has more latitude to reorganize the join order and can short circuit the process if there is not a corresponding row. This is completely secondary to getting the right result set for your query. If there is the possibility of a row in the parent table not joining and needing to be part of the result then you must use left. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org