Skip to Main Content

forall or insert into..select from table(collection) ?

user10316500Jun 27 2014 — edited Dec 12 2017

Hi

In my procedure

1) I fetch more or less 400 000 records with a bulk collect (limit 20 000)    

2) forall insert for each 20 000 records

My question is : I get more performance with FORALL INSERT or using INSERT INTO TABLE ..SELECT * FROM TABLE(collection_name) ?

NB: collection is a table of an object type

Stefano

Comments
Post Details
Added on Jun 27 2014
9 comments
1,804 views