Re: SQL fast, PL/SQL slow, optimizer confused.

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 24 Feb 2004 23:17:18 +0100
Message-ID: <5ajn30h2fb18m5up6jsn0f2lk6t4j93ukm@4ax.com>

On 24 Feb 2004 21:09:10 +0000, Ed Avis <ed_at_membled.com> wrote:

>Stephan Bressler <sbresslerx_no_spam_at_arcor.de> writes:
>
>>pl/sql always uses bind veriables, even explicit values are
>>translated into bind variables. This might give the optimizer fewer
>>information about the cardinality of the index access.
>
>Is this true even for 'execute immediate'?

No.
It isn't true for pl/sql either. the observed behavior for pl/sql only applies when cursor_sharing = force

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Feb 24 2004 - 16:17:18 CST