RE: [Q] does outer join cause full table scan?
- From: "Sinardy Xing" <SinardyXing@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 2 Apr 2004 18:02:28 +0800
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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
