brandon.raines_at_gmail.com schrieb:
> Hi,
>
> I am trying to determine which is a better choice for moving large sets
> of data (performance-wise)- a standard SQL statement INSERT INTO ...
> SELECT .... or to take the same statement and create a PL/SQL
> Procedure that uses BULK COLLECT. If you could also illuminate why one
> works better than the other, I would appreciate it.
>
> Thanks!
> JR
>
I think Tom Kyte said: If you can do it in SQL, use SQL. If you can't do
it in SQL, use PL/SQL. So, why don't you implement both approaches and
test it for performance, resource consumption,...
--
Gruesse,
Thomas Seck
Received on Wed Aug 02 2006 - 16:52:30 CDT
