Perfomenec with update Set stamnt
I am writing below logic to update the DB tables. but when I am cming to the stament it is taking long time, and giving the TIME out error .
Please find the below code.
UPDATE MARC CLIENT SPECIFIED
SET ZC_LT = W_ZC_LT_F
ZT_LT = W_ZT_LT_F
WHERE MATNR = IT_STB-MATNR
AND WERKS = IT_STB-WERKS.
How can i increase performence for above stamt. or give me the alternative solution.