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>
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