Solution : https://service.sap.com/sap/support/notes/1622681 (SAP Service marketplace login required)
Summary :
This SAP Note describes SQL enhancements through DBSL hints specifically for SAP HANA databases. It introduces 'dbsl_equi_join' for optimizing EQUI join execution using FOR_ALL_ENTRIES in ABAP programs and directs the DBSL on how to process the hint in conjunction with the '&prefer_join 1' DBI interface hint. Additionally, 'dbsl_add_stmt' allows for the injection of extra SQL statements into existing commands, with specific syntactic guidance provided for ABAP implementations. The note provides detailed SQL command transformations to demonstrate how ABAP directives translate into SQL queries, optimizing data retrieval and manipulation processes in SAP HANA environments.
Key words :
patch level 103803 dbsl notein release 7, %_hints hdb '&prefer_join 1&' hdb 'dbsl_equi_join', table t_node%_hints hdb 'dbsl_add_stmt, patch level 103720-ext dbsl, keyword %_hints hdb, keyword %_hints adabas, sap hana database, sap hana solution, dbsl_add_stmt <sql enhancement>, database interface ensures
Related Notes :
| 1662726 | Optimizing select with FOR ALL ENTRIES in SAP HANA database |
| 1644059 | ERP Accelerators: Connection to Financial Accounting |
| 48230 | Parameters for the SELECT ... FOR ALL ENTRIES statement |
| 19466 | Downloading SAP kernel patches |