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

wow Steve, where have you been?

-----Original Message-----
From: Steve Adams [mailto:steve.adams@xxxxxxxxxxxx]
Sent: 02 April 2004 17:55
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: [Q] does outer join cause full table scan?


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=3D20

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


Is that always true?

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

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: