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: Dynamic SQL Performance Question

Re: Dynamic SQL Performance Question

From: <billmil_at_my-deja.com>
Date: 2000/04/14
Message-ID: <8d7eok$iq1$1@nnrp1.deja.com>#1/1 







> the elapsed/cpu time for executing dynamic sql is taken up in the

parsing phases.



Thanks for the input, both of you. We're going ahead and replacing all
dynamic sql with stored procedures.  It seems that the performance
benefit from stored procedures outweighs the (one time) cost of
developing them.



bill milbratz


chicago






Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Fri Apr 14 2000 - 00:00:00 CDT












Original text of this message













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