SAP Note 816915 - Bad performance when accessing table VTFA

Component : Transportation Planning and Processing - Transport Freight Processing

Solution : https://service.sap.com/sap/support/notes/816915 (SAP Service marketplace login required)

Summary :
The SAP note addresses performance issues when accessing the VTFA table in transactions or programs related to shipments or freight costs and document flows like sales order or delivery. Identified on Oracle Database 10g, where the rule-based optimizer is unsupported post-10.1 release, it results in performance degradation. SAP users on Oracle 10g are advised to apply the provided non-standard code changes to enhance performance when querying the VTFA table.

Key words :
prerequisites prerequisites database system, oracle release 10g reason, oracle database 10g release 1, terms oraclehints rule reason, rule based optimizer, symptom transactions, freight costs, document flow, preceding documents, sales order

Related Notes :

369658SD document flow: Long runtimes when reading transport doc.