hi i was wondering which statement is quicker getting results when joining
tables ? i presume something like FROM foo f LEFT JOIN bar b ON f.id=b.id is
quiker than WHERE f.id=b.id ?
SQL !! (ignore this)
-
Before posting, please
slow on some massive tables
and would like to optimise the join if possible
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Harald Fuchs
Sent: Wednesday, February 26, 2003 11:26 PM
To: [EMAIL PROTECTED]
Subject: Re: JOIN compared to WHERE clause
In article &l