Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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 …

Best regards

Carlos Behlau

Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question