Re: Compare sql and dynamic sql

If you change to using host variables in the insert statement then it could 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 CPU usage would allow things to scale better if that is a concern. insert into foo_1 values (:firstCol,:secondCol);

Jim

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 Thu Sep 30 1999 - 00:00:00 CEST