| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] does outer join cause full table scan?
wow Steve, where have you been?
-----Original Message-----
From: Steve Adams [mailto:steve.adams_at_ixora.com.au]
Sent: 02 April 2004 17:55
To: oracle-l_at_freelists.org
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
-- 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_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:58:56 CST
 |
 |