Re: Strange problem.

From: Chuck <skilover_nospam_at_softhome.net>
Date: Tue, 6 Dec 2005 20:10:00 +0000 (UTC)
Message-ID: <Xns97249A478C434skiloversofthomenet@213.155.197.138>

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? Received on Tue Dec 06 2005 - 14:10:00 CST