[SAP upgrade] SUM phase RUN_RSAIMMERGE_TRANSFER: Long runtime during upgrade

Solution

1. Recreate the index 1 on the table E071 (defined for the fields PGMID, OBJECT and OBJ_NAME).

2. Refresh the statistics for the table E071.

Alternatively, if creating an additional index is an option:

1. Create an index on the table E071 for the fields TRKORR, PGMID, OBJECT and OBJ_NAME.

2. Refresh the statistics for the table E071.

Repeat the phase RUN_RSAIMMERGE_TRANSFER.

 

refer to note:2496666 - RUN_RSAIMMERGE_TRANSFER: Long runtime during upgrade or EHPI - recommendations