Re: stored outlines used but wrong plan executed

• Post for FREE via your newsreader at post.usenet.com ****

"Arik" <arik_samson_at_excite.com> wrote in message news:699f12fe.0409161337.6ec7abec_at_posting.google.com...
> I wonder if anybody has stumbled upon the same problem:
> Trying to optimize a query in version 9.2.0.4 with a stored outline. I
> manipulated the outline to have the right hints, altered session to
> use the outline, but when I run the query, although the outline is
> used, the wrong plan is executed.
>
> Thanks,
> Arik

Hi Arik

I already had similar problems. Since outlines are hints and, like any hints, sometimes the CBO decide not using them, it happens that an outline simply doesn't work :-(

How did you modify the outline? If you used the Outline Editor, did you get the "correct" plan when you tried to validate the changes?

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=