Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How Can I force SQL to use a specific plan?
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 Thu Sep 06 2001 - 04:25:17 CDT