From: Martijn Tonies
Date: April 5 2009 5:50pm
Subject: Re: Are equi-joins faster than left joins?
List-Archive: http://lists.mysql.com/mysql/216994
Message-Id: <009201c9b617$05a5e130$1401a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit



>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?

Who cares, they are -different- things symantically, use the correct type of
join for your data and resultset. "Speed" is an implementation issue, a
physical property.



With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com