Re: How "deterministic" are EXPLAIN PLAN results?

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Wed, 09 Apr 2003 19:04:11 +0200
Message-ID: <1jk89vo64iubghsbnb6o6aro39l8njo44i@4ax.com>

On Wed, 9 Apr 2003 09:49:16 -0700, "Mikito Harakiri" <mikharakiri_at_ywho.com> wrote:

>"Alex Filonov" <afilonov_at_yahoo.com> wrote in message
>news:336da121.0304090721.4a4f407a_at_posting.google.com...
>> But, for example, statement
>> within PL/SQL block may have different plan than the same statement
>> executed directly.
>
>Why?
>

Because in PL/SQL blocks the optimizer always goes for ALL_ROWS mode, and first_rows hints are ignored.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Apr 09 2003 - 12:04:11 CDT