Yes, full outer joins generally require more cpu time as well as query processing time.
Depending on the size of your query though, you may not notice a difference unless it's a large return. _____________________________ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -----Original Message----- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 24, 2002 6:32 PM To: CF-Talk Subject: RE: QUERY Differences? Hi Steve, Thanks. Does that imply that full outer joins are more expensive than specific inner joins like in your example? At 10:06 PM 2/23/02 -0500, you wrote: >Another way you could do it is: > >SELECT h.History_ID, h.LastName, h.FirstName >FROM History h >INNER JOIN Operator o >ON h.Device_ID = #Client.wDevice_ID# >WHERE o.Operator_ID = h.Operator_ID_Out >AND h.History_ID > #Client.wLastHistory_ID# > >Not really sure which is faster, but I tend to see Joins used more then >commas (commas being a full outer join anyways) >_____________________________ >steve oliver >senior internet developer >atnet solutions, inc. >http://www.atnetsolutions.com > > >-----Original Message----- >From: Brian Scandale [mailto:[EMAIL PROTECTED]] >Sent: Saturday, February 23, 2002 9:48 PM >To: CF-Talk >Subject: QUERY Differences? > > >These two selects BOTH work. > >They report very similar execution times. > >Is one method preferred? Better? Technically Correct? > >------------ >SELECT History_ID, LastName, FirstName >FROM History, Operator >WHERE History.Device_ID = #Client.wDevice_ID# >AND Operator_ID = History.Operator_ID_Out >AND History_ID > #Client.wLastHistory_ID# > >------------ >Select History_ID, LastName, FirstName >FROM History, Operator >WHERE History.Device_ID = #Client.wDevice_ID# >AND Operator_ID = History.Operator_ID_Out >AND History_ID IN > (SELECT History_ID > FROM History > WHERE History.Device_ID = #Client.wDevice_ID# > AND History_ID > #Client.wLastHistory_ID#) > >------------ >thanks, >Brian > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
