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…