Re: How "deterministic" are EXPLAIN PLAN results?

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Wed, 9 Apr 2003 11:10:20 -0700
Message-ID: <csZka.8$PD5.119@news.oracle.com>

"Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message news:1jk89vo64iubghsbnb6o6aro39l8njo44i_at_4ax.com...
> Because in PL/SQL blocks the optimizer always goes for ALL_ROWS mode,
> and first_rows hints are ignored.

Old heuristic-based "first_rows" or new cost-based "first_rows"?

Even if it's true, then it's just an ugly artifact that could be submitted as bug. Essentially it is saying that PL/SQL client code is different from anything else. As if a user can't open cursor in PL/SQL block and fetch 10 first rows only. Received on Wed Apr 09 2003 - 13:10:20 CDT