Re: Fudging outlines

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 6 Mar 2003 17:29:57 -0000
Message-ID: <b481br$ed1$1$8300dec7@news.demon.co.uk>

Yes.

There are a couple of version-dependent
articles at:

www.dbazine.com

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______March 19th
____UK_______April 8th
____UK_______April 22nd

____USA_(FL)_May 2nd


Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA_(CA, TX)_August


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Chuck" <chuckh_at_softhome.net> wrote in message
news:Xns933678C793A0Bchuckhsofthomenet_at_130.133.1.4...


> 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?

Received on Thu Mar 06 2003 - 11:29:57 CST