Are left joins more efficient?

From: Date: Mon, 25 Aug 2003 16:59:21 +0000
Subject: Are left joins more efficient?
Groups: php.general 
Request: Send a blank email to php-general+get-156902@lists.php.net to get a copy of this message
Hello, I program for a website that gets massive loads of traffic. Optimisation has become an important issue lately. At the moment, all queries on the website follow the same format when joining tables: SELECT * FROM table1,table2 WHERE table1.id=table2.id; My question is, would this format be more efficient? SELECT * FROM table1 LEFT JOIN table2 ON table1.id=table2.id; Over the last couple of years I have read and heard two different answers. Years ago it was said that doing Left Joins are faster and more efficient. But with recent updates to MySQL I have read that both queries are broken down and optimised the same way by MySQL. Any thoughts? I havn't come across any comparisons on the web, so any answers would be appreciated. (couldn't find any mysql specific groups so i'm posting in the next best thing!) Thanks -Dennis

« previous php.general (#156902) next »