Performance tuning for DB Updates

Former Member — Thu, 17 Jan 2008 16:32:32 GMT

What should be taken care of for Database updates in ABAP?

Re: Performance tuning for DB Updates

Former Member — Thu, 17 Jan 2008 16:37:39 GMT

All Database manipulations in SAP (UPDATE, INSERT, DELETE) can be executed one record at a time or through an 'Array' operation.

Example:

No good

LOOP AT T_MAT.

……

UPDATE MARA SET MATKL = T_MAT-MATKL.

WHERE MATNR = T_MAT-MATNR.

ENDLOOP.

GOOD

LOOP AT T_MAT.

……

ENDLOOP

UPDATE MARA FROM TABLE T_MAT.

After the execution of the array update, the following system fields are populated:

• SY-SUBRC - Contains 0 if all updates were successfully executed

• SY-DBCNT -Contains the number of successfully updated records

Restrictions:

• The Array update function can't be combined with UPDATE SET

Recommendation:

• Array updateIf a large number of fields are changed in multiple records

• Update setIf a small number of fields are changed in one record

• If a small number of fields are changed in multiple records

-> Define a modifiable view using the key fields and the fields which are to be changed

Updating Key fields

Key fields can be updated for transparent tables just like any other table.

Exception:

If synchronous match codes exist for the table, the key field update will be unsuccessful.