Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How Can I force SQL to use a specific plan?

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

From: Christof Kaiser <Kaiser_at_logiball.de>
Date: Thu, 06 Sep 2001 11:25:17 +0200
Message-ID: <3B9740FD.83BE8A22@logiball.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US