Re: Bulk Collect vs. Insert Into

On 2 Aug 2006 14:40:48 -0700, brandon.raines_at_gmail.com wrote:

>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

insert into select would be faster and consume less resources as this is a server side operation and the data isn't fetched.

--
Sybrand Bakker, Senior Oracle DBA