Pl/SQl bulk update versus SQl update [message #226232] |
Fri, 23 March 2007 00:32  |
friendarora
Messages: 24 Registered: February 2007
|
Junior Member |

|
|
Hi,
I need to know which is a better approach out of bulk update (PL/SQL)and a simple update(SQL) to choose for the data migration , which may range from 100 records to 1 million records at a time
Thanks in advance
|
|
|
Re: Pl/SQl bulk update versus SQl update [message #226238 is a reply to message #226232] |
Fri, 23 March 2007 01:11  |
rleishman
Messages: 3728 Registered: October 2005 Location: Melbourne, Australia
|
Senior Member |
|
|
PLSQL FORALL statements with bulk binds to arrays of 100 or more rows will perform similarly to SQL Update. It will probably be a little slower, but not more than 5%.
Single row PL/SQL updates inside a loop will be orders of magnitude slower.
Ross Leishman
|
|
|