SAP Note 150037 - Database hints in Open SQL for DB6 (DB2 for LUW)

Component : DB2 Universal Database for Unix / NT -

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 :

1484907DB6: Conditional hints
1292796DB6: Indirect hints in Open SQL (DB2 for LUW)
1143736DB6: User-Exit for Datenbank-Hints in SAP BI 7.x
868888 DB6: Optimization Guidelines
129385Database hints in Open SQL