Home » SQL & PL/SQL » SQL & PL/SQL » Pl/SQl bulk update versus SQl update
Pl/SQl bulk update versus SQl update [message #226232] Fri, 23 March 2007 00:32 Go to next message
Messages: 24
Registered: February 2007
Junior Member


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 Go to previous message
Messages: 3724
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
Previous Topic: Using BULK COLLECT
Next Topic: Date calculation..effective ways
Goto Forum:

Current Time: Wed Oct 26 12:29:48 CDT 2016

Total time taken to generate the page: 0.22394 seconds