Compare sql and dynamic sql
From: Jay <mighty_dragon_at_hotmail.com>
Date: 1999/09/30
Message-ID: <37F37FD5.1D9B1096_at_hotmail.com>#1/1
Date: 1999/09/30
Message-ID: <37F37FD5.1D9B1096_at_hotmail.com>#1/1
For a large number of sql statements w/c contain a pattern, for example:
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.
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);
Can anyone explain any reason why using stored procedures would be slower.
Thanks in advance for any help. Received on Thu Sep 30 1999 - 00:00:00 CEST