> then, at a minimum, Oracle MUST FTS the driving table. That's because
there are no filter predicates. If the statement looked something like:

Just a small out-of-context comment: CBO can decide to use index for full
scans without filter predicates as well, in case all required columns exist
in an index and fast full scan can be used...

Tanel.


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