Re: [Q] does outer join cause full table scan?
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 2 Apr 2004 13:38:01 +0300
> 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@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:
