Re: execution plan different inside stored procedure?

From: Donetskov Dmitry <dmdp_at_mail.ru>
Date: 28 Aug 2002 02:39:55 -0700
Message-ID: <db37736f.0208280139.38d34858_at_posting.google.com>


PL/SQL blocks (both anonymous blocks and stored procedures) should use explicit HINTs to determine the actual optimization method. In the absence of hints, parallelism or 'CBO-only' objects then the optimizer used for SQL in PLSQL blocks uses the following mode:

INIT.ORA OPTIMIZER_MODE		Mode used in PLSQL
~~~~~~~~~~~~~~~~~~~~~~~		~~~~~~~~~~~~~~~~~~
RULE				RULE
CHOOSE				ALL_ROWS
ALL_ROWS			ALL_ROWS
FIRST_ROWS			ALL_ROWS

Metalink Note 35934.1

Dmitry Donetskov Received on Wed Aug 28 2002 - 11:39:55 CEST

Original text of this message