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 -> How Can I force SQL to use a specific plan?

How Can I force SQL to use a specific plan?

From: jaimin saraiya <jsaraiya_at_hotmail.com>
Date: 5 Sep 2001 12:36:12 -0700
Message-ID: <abb3ac41.0109051136.5699059e@posting.google.com> 





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 Wed Sep 05 2001 - 14:36:12 CDT












Original text of this message













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