Which is better (insert select) or (loop insert)
Hi All
Kindly, I have one view reading from different databases using DB links,
I need to build a procedure to move the data from that view to a table 2 times per day (around 700K records for each run),
Which is better from the performance point of view: or there is another (C) option which better from both of the following 2 options?
(A) insert as select all records from the view
Insert into Table1
select v1.*,null,null,null from View1 v1
join Table2 t2
on v1.id = t2.id;
commit;
(B) we have a table containing the parent id, to use in a loop and insert from 10 to 20 records with each loop and commit every 10K insert transactions