SAP Note 162034 - DB2/390: Database hints in Open SQL

Component : DB2 for z/OS -

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

Key words :
OPEN SQL, hint, database hint, optimizer hint, optimizer, %_HINTS, reoptimization, ABAP, runtime, performanceDB2 MVS OS390

Related Notes :

1009808MM_MATNR: Performance problems during reading of EQUI or OBJ
998448MM_MATNR: Performance problems when reading table AFIH
932243Conversion from IPPE to BOM
893602SBWP: Response time problems with DB2 database
860798Expensive SQL statements in transaction PT68 (DB2/390)
798360DB2 specific ABAP hints in Include RPTEXIN2
770471MM_MATNR: Performance problems reading AFVC
724614DB2-z/OS: Database hints in Open SQL as of Kernel Rel 6.20
687246Move-out: Performance problems ISU_DB_EVER_SINGLE_TRANSVER
564019Access to VTFA for the DB2 database takes long
561497FM_FIPEX_GET_FROM_POSIT DB2 bad performance
498996DB2:Performance problems when creating project with template
496167IS-H: Poor performance during free time slot search in DB2
429146CC04, CC03: long runtime due to Full Table Scan
410400GET_PS_OBJECTNUMBER: Access problems with database DB2
129385Database hints in Open SQL
113008DB2/390: Maintaining Catalog Statistics
81737DB2-z/OS: APAR List