Re: Execution plan in stored procedures

A copy of this was sent to "Adrian Bowen" <adrian_at_raptor.win-uk.net> (if that email address didn't require changing) On Mon, 21 Jun 1999 17:30:07 +0100, you wrote:

>Are plans not frozen when a package is built, though? I've been trustingly
>setting optimiser_goal from SQLPlus before issuing CREATE PACKAGE BODY,
>assuming that the execution plans for implicit and explicit cursors within
>the package would then be fixed.
>
>Adrian.
>

No they are not. PL/SQL uses 'choose' at run time to set the plans. If you want it to use a specific mode -- you would hint the queries.

Optimizer goal applies only to queries submitted directly. It does not apply to recursive SQL or to triggers or sql in PL/SQL.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Fine Grained Access Control", added June 8'th  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jun 21 1999 - 14:13:15 CDT