----- Original Message -----
Sent: Thursday, March 06, 2003 12:19
PM
Subject: RE: Fudging outlines
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]]
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?
--
Please see the official ORACLE-L
FAQ: http://www.orafaq.net
--
Author: Chuck Hamilton
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in
the message BODY, include a line
containing: UNSUB ORACLE-L
(or the name of mailing
list you want to be removed from). You may
also
send the HELP command for other information (like subscribing).
