I don't think one test can be seen as proof of either way being better or faster - there's a lot more that goes into DB performance than JOIN vs. =. Indexes, constraints, what mood your OS is in, etc.
True story: a company I worked for had to fire a Microsoft Certified Professional (actually, an MCSE) after watching him try to install a 3Com NIC into a Windows 2k box for two days. Not to say there aren't good ones, but I've a shifty amount of trust ever since. -Joe On Apr 5, 2005 11:28 AM, David Manriquez <[EMAIL PROTECTED]> wrote: > I'm still using it cause a Microsoft Certified SQL professional show me the > tracing and performance of "LEFT/RIGHT/OUTHER/INNER JOIN and *=/=/=*/*=* > and the last one is better and faster. > > > David Manriquez > Desarrollador de Sistemas > [EMAIL PROTECTED] > (+56-2) 43 00 155 > > -----Mensaje original----- > De: Matt Osbun [mailto:[EMAIL PROTECTED] > Enviado el: Martes, 05 de Abril de 2005 11:18 > Para: CF-Talk > Asunto: RE: SQL prob > > Why? Not a challenge, but a question. Using *= or (+) always seemed, > at least to me, quicker, easier, and easier to read afterward. > > Now, I admit that I mostly got into the habit because, until fairly > recently, I was stuck on an Oracle platform that was too old to use > INNER JOIN/LEFT JOIN, but how much does it really matter? > > Matt Osbun > Web Developer > Health Systems, International > > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 05, 2005 9:42 AM > To: CF-Talk > Subject: RE: SQL prob > > This is the OLD way to perform a join - it should be avoided. > > -----Original Message----- > From: David Manriquez [mailto:[EMAIL PROTECTED] > Sent: 05 April 2005 15:48 > To: CF-Talk > Subject: RE: SQL prob > > Another way > > SELECT r.eventID, d.title > FROM Events r,EventDescription d > WHERE d.eventID *= r.eventID > > David Manriquez > Desarrollador de Sistemas > [EMAIL PROTECTED] > (+56-2) 43 00 155 > > -----Mensaje original----- > De: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Enviado el: Martes, 05 de Abril de 2005 10:17 > Para: CF-Talk > Asunto: RE: SQL prob > > You are using an INNER JOIN - you need to use a LEFT JOIN I believe. > > SELECT r.eventID, d.title > FROM Events r > LEFT JOIN EventDescription d > ON WHERE d.eventID = r.eventID > > -----Original Message----- > From: Dave Francis [mailto:[EMAIL PROTECTED] > Sent: 05 April 2005 15:18 > To: CF-Talk > Subject: OT:SQL prob > > SQL Server 7. > > <cfquery name="q1" datasource="newStuff"> > SELECT r.eventID, d.title > FROM Events r, > EventDescription d > WHERE d.eventID = r.eventID > </cfquery> > > This query only returns rows from "Events" table that have eventID > present in "EventDescription" table. I need to return ALL rows from > Events table whether thay have a description or not. > > As ever, thanks in advance, > Dave > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201511 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
