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

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
Received on Fri Sep 14 2001 - 04:45:09 CDT