SAP Accounting Consulting

Symptom

Select on the table BUT000 takes very long since there is no index
Other terms

LBUPA_INTERFACE_TDTRANSF01, perform partner_determine, BUT000
Reason and Prerequisites

The index BUT000~ADR is non-unique and the optimizer doesn’t hit the index at all and chooses to go for table scan.
The query has to be changed to use a hint.
If the customer is using ORACLE DB then a hint statement can be added to improve the performance
But please note that the customer has to use ORACLE DB for the improvement to be seen.
Solution

Please apply the source code correction to improve the performance.