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. -- Regards, Stephane Faroult Oriole Software ---------------------------------------------------------------- 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 -----------------------------------------------------------------