Definitely insert into table select * from table2

-----Original Message-----
From: Oracle DBA Help [mailto:[Email Address Removed] Wednesday, March 31, 2004 4:09 PM
To: LazyDBA.com Discussion
Subject: curious w/ insert

I'm just curious, and I unfortunately do not a have test database to try this out, but which is faster
doing a direct insert (insert into table select * from table2) or doing a bulk collect then forall insert?
Oracle LazyDBA home page