It is Note 92202.1 - How to specify hidden hints on SQL statements
with a prominent disclaimer:
Disclaimer:
This script is provided for educational purposes only. It is NOT
supported by Oracle Support Services. The script has been
tested and appears to work as intended. However, you should always
test any script before relying on it.
At 09:19 AM 3/6/2003 -0800, you wrote:
>Yup ... and oracle has a note that tells you how.
>
>Raj
>-------------------------------------------------------------
>Rajendra dot Jamadagni at espn dot com
>Any views expressed here are strictly personal.
>QOTD: Any clod can have facts, having an opinion is an art !!
>
>-----Original Message-----
>From: Chuck Hamilton [<mailto:[EMAIL PROTECTED]>mailto:[EMAIL PROTECTED]]
>Sent: Thursday, March 06, 2003 11:39 AM
>To: Multiple recipients of list ORACLE-L
>Subject: Fudging outlines
>
>I have an application query that I do not have the source code for. It gets
>a crappy execution plan. I can add a hint or two to it and significantly
>improve the execution plan. I want to stuff that execution plan into a
>stored outline so that the unhinted query uses that plan plan each time it
>executes. Can this be done?
Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com
********************
This email communication is intended as a private communication for the sole use of the primary addressee and those individuals listed for copies in the original message. The information contained in this email is private and confidential and if you are not an intended recipient you are hereby notified that copying, forwarding or other dissemination or distribution of this communication by any means is prohibited. If you are not specifically authorized to receive this email and if you believe that you received it in error please notify the original sender immediately. We honour similar requests relating to the privacy of email communications.
Cette communication par courrier électronique est une communication privée à l'usage exclusif du destinataire principal ainsi que des personnes dont les noms figurent en copie. Les renseignements contenus dans ce courriel sont confidentiels et si vous n'êtes pas le destinataire prévu, vous êtes avisé, par les présentes que toute reproduction, tout transfert ou toute autre forme de diffusion de cette communication par quelque moyen que ce soit est interdit. Si vous n'êtes pas spécifiquement autorisé à recevoir ce courriel ou si vous croyez l'avoir reçu par erreur, veuillez en aviser l'expéditeur original immédiatement. Nous respectons les demandes similaires qui touchent la confidentialité des communications par courrier électronique.
