Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL fast, PL/SQL slow, optimizer confused.

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

From: Ed Avis <ed_at_membled.com>
Date: 24 Feb 2004 21:09:10 +0000
Message-ID: <l1brnombgp.fsf@budvar.future-i.net>


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

-- 
Ed Avis <ed_at_membled.com>
Received on Tue Feb 24 2004 - 15:09:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US