Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL fast, PL/SQL slow, optimizer confused.
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
![]() |
![]() |