Re: Help with sql query speed. Explain plan included

On Mar 19, 5:49 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Charles Hooper wrote:
> > I just completed some rather extensive testing of this problem on
> > Oracle 10.2.0.3 running on Windows Vista. The results were not quite
> > was I expected. 10.2.0.3, at least on this platform, seems to ignore
> > hints.
>
> Speaking of hints you just reminded me that in the current issue of
> Oracle Scene, the UKOUG's magazine, Issue 29, page 30, there is an
> article by Bob Mycroft on using Plan Stability to do what Advanced
> Rewrite doesn't ... place hints into code when you can not get to the
> source.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

I will have to look into that as an option for a couple issues that I have with packaged applications. Thanks for the suggestion.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Mon Mar 19 2007 - 20:42:08 CDT