RE: [Q] does outer join cause full table scan?

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Fri, 02 Apr 2004 19:55:29 +1000
Message-ID: <000c01c41898$9d014be0$ae8735cb@ixora.com.au>

Hi All,

I can confirm that 10g can now use the deficient row source as the build input.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all=20

-----Original Message-----
From: Bobak, Mark

Is that always true?

I seem to remember a discussion a while back on the OakTable list = regarding
hash outer joins, and that Oracle would not use the deficient row source = as
the driving table, though there was no good reason not to. The reply = was
that it was true for current Oracle releases, and seemed to imply that = it
was going to be fixed in a future release. I haven't tested 10g to see = what
it does.

-----Original Message-----
From: Lex de Haan

a small correction: in an outer join, there is no choice for the driving table

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Apr 02 2004 - 03:52:01 CST