mass delete form database or using the SET statement

[Former Member]

Hi

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

[venkat_o]

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