Solution : https://service.sap.com/sap/support/notes/150037 (SAP Service marketplace login required)
Summary :
This SAP Note guides users on improving OPEN SQL statement efficiency via DB2 Optimizer or SAP database interface hints. It supplements Note 129385 with specific guidelines for DB6, detailing usage of two types of hints: Optimization Guidelines and indirect hints for dynamic SQL scenarios. The note insists on the importance of only using these hints after reviewing relevant guidelines. The Optimization Guidelines allow explicit access plan optimization, unaffected by table statistics or DB2 system upgrades. In contrast, indirect hints are used when direct optimization isn't feasible, aided further by the insights from Note 1292796. Users are advised to use indirect hints sparingly.
Key words :
svers%_hints db6 '<ixscan table=''svers'' index='', avoid including indirect hints, direct open sql hint, dynamic open sql statements, explicit db2 optimization guideline, dynamic table names, open sql statement, terms open sql, open sql hints, providing additional rules
Related Notes :
1484907 | DB6: Conditional hints |
1292796 | DB6: Indirect hints in Open SQL (DB2 for LUW) |
1143736 | DB6: User-Exit for Datenbank-Hints in SAP BI 7.x |
868888 | DB6: Optimization Guidelines |
129385 | Database hints in Open SQL |