Skip to Content
avatar image
Former Member

How HANA DB Hint improves performance of For All Entry in ABAP

Dear Experts,

We added HANA DB Hint in all places to improve the performance of codes having All Entry using Function Module RSDU_CREATE_HINT_FAE.

In many areas it has improved the code performance significantly.

But I am still not able to understand how its works or how does it improves the performance.

Please help me to understand.

Thanks,

Ankush Sharma

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Mar 22, 2017 at 09:24 AM

    As I am not on a HANA-System I can't verify this, but you should look at SAP-KBA's :

    • 1662726 - "Optimization of select with FOR ALL ENTRIES on SAP HANA database" which mentions the FM "RSDU_CREATE_HINT_FAE" and the HANA-hints (DBSL hint 'dbsl_equi_join' / DBI hint 'prefer_join') that will be set up correctly to improve performance ...
    • 1622681 - "DBSL hints for SAP HANA" which lists the Hints mentioned ...
    • 48230 - "Parameterization of SELECT ... FOR ALL ENTRIES statement" explaining in general


    I hope some-one can explain this clearer than in the KBA's or even provide a BlogPost on it, but these KBA's might help in the meantime?


    Kind regards

    Nic T.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 22, 2017 at 08:54 AM

    Have you followed through what the FM does? Have you seen it calls FM RSDU_CREATE_HINT_FAE_HDB to do its actual work? You can figure out from there some of the details of how it works.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 22, 2017 at 09:12 AM

    See SAP Note 1662726 ...

    (but obsolete since Release 7.50, from then on profile parameter rsdb/prefer_join_with_fda can be used)

    PS: I'm not an expert for that ...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 22, 2017 at 01:49 PM

    I know how to use FM and we have added in many places. I am more curious in the functionality of HANA DB HINT, I know it improves performance but how ?

    Regards,

    Ankush

    Add comment
    10|10000 characters needed characters exceeded