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

Ed Avis 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.

Not at all. For dynamic SQL use the USING clause.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)