topic mass delete form database or using the SET statement in Application Development and Automation Discussions

mass delete form database or using the SET statement

Former Member — Wed, 17 Mar 2010 05:57:24 GMT

I i need to update in a custom table on the database ( it's only one column)

Which is more performance doing a mass update that is

Update datab from itab

or usgin update datab set xxx where xxx = xxx ( this will be found in a loop)

note that i still need to do loop to enqeue the data

Re: mass delete form database or using the SET statement

venkat_o — Wed, 17 Mar 2010 06:01:08 GMT

Hi,

Update datab from itab

<li>Get the data to itab(type dbtable) and loop the itab table and change the column and after LOOP-ENDLOOP use above statement instead of hitting database for every loop. Thanks Venkat.O

Edited by: Venkat.O on Mar 17, 2010 2:02 PM