Re: Strange problem.

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 06 Dec 2005 15:49:01 -0800
Message-ID: <1133912921.463692@jetspin.drizzle.com>

Chuck wrote:
> DA Morgan <damorgan_at_psoug.org> wrote in
> news:1133899013.503150_at_jetspin.drizzle.com:
>
>
>

>>Play with the NO_UNNEST and UNNEST hints.

>
>
> That essentially what I did in the OP. My problem is that the explain plan
> being chosen by the optimizer when I actually run the SQL appears to be
> different than what explain plan says it's going to choose. I'm
> determining this with sqltrace and tkprof. Is the execution plan reported
> by tkprof guaranteed to be what actually executed?

Guaranteed is an extreme statement.

Guaranteed to be what Oracle would do at that instant with that data on that server. Inserts, updates, deletes, fresher statistics, etc. may change it at any time.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Tue Dec 06 2005 - 17:49:01 CST