I wasn't disagreeing with you - I'd like to know which is quicker, and if I have 5 mins I'll test it, but I don't, so perhaps someone else can...
> -----Original Message----- > From: Stephen Moretti [mailto:[EMAIL PROTECTED]] > Sent: 19 September 2002 14:35 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] SQL question - brain a blank! > > > > run the query analyser to see which is quicker.... > > > > Ok - I'll take your word for it, but really the JOINs should > be much more > effiecient than sub-queries and not the other way around, _as > long as_ you > have set up your database and your indexes correctly... > > A rumour I've just been told.... Apparently, Oracle is supposed to do > sub-queries better than joins.... > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
