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

  • From: Stephane Faroult <sfaroult@xxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 30 Mar 2004 20:42:20 +0200

dba1 mcc wrote:
> We have sql statement outer join two tables.  The join
> columns have index on it.  I use "tkprof" to check it
> and it show full table scan.
> Does outer join cause 'full table scan"?
> Thanks.

Nothing causes something 'per se' with the CBO. What may matter is
whether the column you are outjoining on (ugly expression) is nullable
or not.


Stephane Faroult
Oriole Software
Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: