RE: dynamic SQL - preformance?

From: Mohoni, Uma <Uma.Mohoni_at_emergis.com>
Date: Tue, 26 Nov 2002 07:43:50 -0800
Message-ID: <F001.0050C009.20021126074350@fatcity.com>

Hmmm! I wonder what happened to the content of this email..?

Anyways,my question was performance wise is the dynamic SQL worse off than compiled code and same as regular SQL being sent to oracle? I have a proc which has a lot of dynamic sql bind variables and all but I am not very happy with its preformance..
Thanks,
Uma

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 11/26/2002 8:43 AM

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.

------_=_NextPart_001_01C29562.8D740600--
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mohoni, Uma
  INET: Uma.Mohoni_at_emergis.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Nov 26 2002 - 09:43:50 CST