Query performance difference pl/sql forall insert and plain SQL insert
Posted
by user289429
on Stack Overflow
See other posts from Stack Overflow
or by user289429
Published on 2010-04-20T05:28:14Z
Indexed on
2010/04/20
5:33 UTC
Read the original article
Hit count: 310
We have been using temporary table to store intermediate results in pl/sql Stored procedure. Could anyone tell if there is a performance difference between doing bulk collect insert through pl/sql and a plain SQL insert.
Insert into
or
Cursor for open cursor fetch cursor bulk collect into collection Use FORALL to perform insert
Which of the above 2 options is better to insert huge amount of temporary data?
© Stack Overflow or respective owner
