> 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]
