Re: Compare sql and dynamic sql

[Quoted] If you change to using host variables in the insert statement then it could [Quoted] be faster since less CPU processing would occur on the server. (after the first statement). The I/O would be about the same in either case; but less [Quoted] CPU usage would allow things to scale better if that is a concern. insert into foo_1 values (:firstCol,:secondCol);

Jim

[Quoted] Jay <mighty_dragon_at_hotmail.com> wrote in message news:37F37FD5.1D9B1096_at_hotmail.com...
> For a large number of sql statements w/c contain a pattern, for example:
>
> insert into foo_1 values (1, one);
> insert into foo_2 values (2, two);
> insert into foo_3 values (3, three);
> ...
> insert into foo_n values (n, n);
>
> Someone had claimed that the above execution is faster than any means
> like using stored procedures with pl/sql OR dynamic sql OR native
> dynamic sql.
>
> Can anyone explain any reason why using stored procedures would be
> slower.
>
> Is there any overhead using dynamic sql over straight sql???
>
> In any case, can anyone refer me to a document that will explain in some
> details how dynamic sql execute internally.
>
>
>
> Thanks in advance for any help.
>
Received on Fri Oct 01 1999 - 02:33:11 CEST