Re: Strange problem.

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

"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in news:1133897567.973214.13360_at_g44g2000cwa.googlegroups.com:

> Explain plan's are often wrong. The 10046 trace info is always
> correct.
>
> You may want to read Tom Kyte's oracle books and/or check out
> asktom.oracle.com ...
>
> # How do I force Oracle to use the plan that explain plan says it's
> going to use?
>
> Well there are some options available again I would refer you to
> asktom.oracle.com
>

Have you got an article number or URL? I've searched asktom.oracle.com for "explain plan" "explain plan wrong" "force execution pan and "execution plan". Each yields hundreds of articles none of which seem to be about forcing oracle to choose the execution plan that explain plan says it's going to choose. Received on Tue Dec 06 2005 - 14:07:00 CST