Skip to Content
0

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

Mar 22, 2017 at 06:58 AM

692

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Nic Teunckens Mar 22, 2017 at 09:24 AM
2

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.

Share
10 |10000 characters needed characters left characters exceeded
Matthew Billingham
Mar 22, 2017 at 08:54 AM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Horst Keller
Mar 22, 2017 at 09:12 AM
1

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 ...

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 22, 2017 at 01:49 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

HANA DB HINTs are documented in the HANA SQL documentation.

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.00/en-US

Cheers!

Horst

2