Bulk Collect vs. Insert Into

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 Received on Wed Aug 02 2006 - 16:40:48 CDT