Re: Pro*C - embedded SQL versues dynamic SQL (performance)

James,

Not so. Oracle executes a parse, execute, fecth for each static SQL command during execution.
To see this, just look at the calls made in the pre-compiler outputted C file. Then swicth to dynamic
SQL and prepare a command and execute it. You will see that some of the calls are now with the
prepare (e.g. before a loop) and the rest are with the execute (e.g. within a loop). We have found
such a trivial change to yield 15-20% runtime improvement.

Bert Scalzo
DBA
EDS Received on Tue May 04 1999 - 09:05:56 CDT