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

user10316500Jun 27 2014 — edited Dec 12 2017

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

Added on Jun 27 2014

9 comments

1,804 views