Re: How Can I force SQL to use a specific plan?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 14 Sep 2001 12:51:47 +0200
Message-ID: <tq3p1gc554hm71@news.demon.nl>

"Markus Stuhlpfarrer" <mstuhlpfarrer_at_hollomey.com> wrote in message news:3BA1D182.A1651892_at_hollomey.com...
> yes, you can try this, but it is possible that it doesn't work
> as the word says, this are hints and not rules
> you cannot really force oracle to do it this way
>
> Christof Kaiser wrote:
>
> > Try optimizer hints.
> >
> > Optimizer hints are inserted after the select, starting with /*+
> > SELECT /*+ ordered */ FROM ....
> >
> > Christof
> >
> > jaimin saraiya wrote:
> >
> > > Hello,
> > >
> > > I have saved a plan using Explain Plan tool. Now I want to force my
> > > SQL Statement to always use that plan during execution. How can I do
> > > this?
> > >
> > > Thank you
> > >
> > > Regards,
> > >
> > > Jaimin
>

In Oracle 8i this can be done by using outlines.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Fri Sep 14 2001 - 05:51:47 CDT