How to tune optimizer?
Hello SAP experts,
we are having a customer written programs, that is accessing table BALHDR.
When I check the SQL trace via ST04, I see it is using the index and performing a range scan.
As our SAP system is based on Oracle/SAP ECC 6 (EHP 5), from my understanding, access to table/indexes are getting also managed by optimizer.
Is there a way to tune optimizer?
I am having a hard time, finding good documentation concerning Oracle/SAP/optimizer concerning its tuning. What I found so far leaves more question marks than it answers.
Some year ago, I had a similar issue and SAP support tuned the optimizer and the performance issues had been resolved.
Thanks for your help pointing me in the right direction …