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


Current Time: Tue Feb 18 20:41:51 CST 2025