RE: Re: Explain plan accuracy and bind variables

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 06 Feb 2004 09:28:25 -0700
Message-Id: <6.0.0.22.2.20040206092118.02a2b800@pop.centrexcc.com>

In my paper "What is new in the 9i CBO" on page 9+ under the heading Explain Plan Dilemma I have an example of a SQL that produces 3 different access plans. One when explained which is different from both actual plans when executed with a frequently occurring value for the bind variable or when executed with a infrequently occurring value. The paper is available at www.centrexcc.com

At 08:01 AM 2/6/2004, you wrote:
>Can someone provide an example of a query that emits STAT lines that
>contradict the output of EXPLAIN PLAN because of the use of bind
>variables?
>
>
>Cary Millsap
>Hotsos Enterprises, Ltd.
>http://www.hotsos.com
>* Nullius in verba *

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

---

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 Feb 06 2004 - 10:28:25 CST