Solution : https://service.sap.com/sap/support/notes/133381 (SAP Service marketplace login required)
Summary :
This SAP Note addresses enhancements to Open SQL hints for efficient SQL Server optimization. A new guideline is introduced, enabling hints as of kernel/DBSL release 4.5B, with further refinements in subsequent releases. Users can implement SQL Server-specific hints by following the integration rules set in the general Note #129385. The ability to specify index usage through hints like INDEX is detailed, alongside conditions where using hints such as &REPARSE and &SUBSTITUTE VALUES can modify query execution plans or recompile procedures as needed. The note emphasizes cautious use of hints, advocating for their application solely when necessary to address specific optimization issues.
Key words :
mssqlnt '&prefer_join 0&' examplesthe abap program attached, profile parameter dbs/mss/fae_join fae_join = 1, arbgb = '00'%_hints mssqlnt 'table &table& abindex, t100 bypassing bufferwhere sprsl = sprsl, %_hints mssqlnt 'table <tablename> abindex, sql-string resulting sql command, theabove-mentioned general note apply, %_hints mssqlnt 'option fae_join', %_hints mssqlnt 'option fae_union', ' mssqlnt 'table &table& fastfirstrow'
Related Notes :
| 1552952 | Parameter maxmarkercnt increased to 10000 |
| 1423845 | Syntax error when using ABINDEX with FOR ALL ENTRIES |
| 821722 | Performance of the join on MSEG and MKPF |
| 811852 | Substitute_Literals to improve access to LTAP |
| 687864 | Performance problem following upgrade to 6.20 basis. |
| 652634 | FOR ALL ENTRIES performance with Microsoft SQL Server |
| 630451 | MSSQL hint causes runtime error. |
| 538078 | OPTION hints for MSSQL don't take effect in FORALLENTRIES |
| 338468 | REPARSE-hint does not work with FOR ALL ENTRIES |
| 159171 | Recompilation of Stored Procedures |
| 129385 | Database hints in Open SQL |
| 28667 | Microsoft SQL Server Specific Profile Parameters |