In my SAP experience, I often find that bad SAP job/program performance is due to poor program internal table handling. This is especially true when most of program/job run time is spent on CPU/ABAP side. One of common performance pitfalls is that internal table reading is not efficient. Read an internal table using binary search…
Tag Archives: SAP performance case study
SAP background job is running long due to inefficient index
In this post, I would show how I did troubleshooting on a long running job. My investigation found that runtime of the job was mostly spent on reading a SAP table VLKPA. The SQL access path chosen by database to read the table is correct based on then-existing VLKPA index. But the index used is…