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
If you can do it with a single SQL statement do so.
If you can't use BULK COLLECT with the LIMIT clause and FORALL.
Also consider the APPEND hint if appropriate.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Aug 03 2006 - 11:50:31 CDT
