Re: Fudging outlines

I should have said:

There are a couple of articles I wrote at

     www.dbazine.com

I wasn't trying to be modest or unassuming.

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


"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:b481br$ed1$1$8300dec7_at_news.demon.co.uk...


>

> Yes.

>

> There are a couple of version-dependent

> articles at:

>     www.dbazine.com

>

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

>

>