Solution : https://service.sap.com/sap/support/notes/129385 (SAP Service marketplace login required)
Summary :
This SAP Note details the integration of database hints within Open SQL statements for optimizing query execution, effective from Release 4.5. Hints allow selective influence over the database optimizer’s operations, tailored to specific database behaviors, thus not universally applicable or beneficial across different systems. They are applicable only to transparent tables or views, not affecting R/3 database buffer operations or pool/cluster table statements. Users assume responsibility for correctness and usefulness of the hint, which should be applied cautiously and ideally under consultation with seasoned developers. The note also emphasizes runtime-only hint evaluation, non-interference with functional output, and system-specific hint applicability. Additionally, database-specific guidance is referenced for further detailing.
Key words :
/3 database interface generates synthetic table aliases, sapdb / maxdb open sql notation, open sql/native sql 652096 database hints, ms sql server 150037 database hints, ] %_hints <selector> '<text>' <selector> '<text>' [, expressly influence decisions made, database interface evaluates hint texts, database-specific notes listed, update open sql statement, database-specific note mentioned
Related Notes :
| 1552952 | Parameter maxmarkercnt increased to 10000 |
| 1367644 | CIC: Poor performing access to data environ. - contract data |
| 1299736 | Planning: Day-Based Planning - Performance |
| 1069739 | CIC: Poor performing access to data environ - bill doc data |
| 1009808 | MM_MATNR: Performance problems during reading of EQUI or OBJ |
| 998448 | MM_MATNR: Performance problems when reading table AFIH |
| 972013 | Performance Blocked Documents Report: Database settings |
| 942042 | Performance problems when rebate agreement is displayed |
| 932243 | Conversion from IPPE to BOM |
| 832544 | FAQ: MaxDB Hints |
| 821722 | Performance of the join on MSEG and MKPF |
| 816056 | Performance problems in V23 and VA14L |
| 811852 | Substitute_Literals to improve access to LTAP |
| 798360 | DB2 specific ABAP hints in Include RPTEXIN2 |
| 797629 | FAQ: Oracle histograms |
| 772497 | FAQ: Oracle Hints |
| 770471 | MM_MATNR: Performance problems reading AFVC |
| 687246 | Move-out: Performance problems ISU_DB_EVER_SINGLE_TRANSVER |
| 652096 | Database hints in Open SQL for SAPDB/MaxDB |
| 630451 | MSSQL hint causes runtime error. |
| 564019 | Access to VTFA for the DB2 database takes long |
| 531337 | iSeries: Performance with Open SQL "FOR ALL ENTRIES" |
| 515886 | REP: Optimization in reading the change pointers for DB2 |
| 515769 | Techn.obj.:Runtime during search for install.eqpmts (EQUZ~H) |
| 485420 | iSeries: Database hints for Open SQL/Native SQL |
| 456066 | Device installation: Index EQUZ~H not used |
| 429146 | CC04, CC03: long runtime due to Full Table Scan |
| 394413 | Long runtime when displaying shipment |
| 380848 | Bad performance when archiving SD_VTTK |
| 369658 | SD document flow: Long runtimes when reading transport doc. |
| 338468 | REPARSE-hint does not work with FOR ALL ENTRIES |
| 176754 | Problems with CBO and RBO |
| 162034 | DB2/390: Database hints in Open SQL |
| 159171 | Recompilation of Stored Procedures |
| 152913 | Database hints in Open SQL for Informix |
| 150037 | Database hints in Open SQL for DB6 (DB2 for LUW) |
| 140825 | Optimizer Hints in Open SQL |
| 131372 | CBO: Tuning of expensive SQL statements |
| 130480 | Database Hints in Open SQL for Oracle |
| 113008 | DB2/390: Maintaining Catalog Statistics |