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

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Fri, 2 Apr 2004 13:38:01 +0300
Message-ID: <0a4801c4189e$936b03e0$6df923d5@porgand>

> 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_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 - 04:34:30 CST