Dynamic Join Vs Optimal join condition

[Former Member]

Hi SAP Community members,

I am exploring on existing Optimal join condition and Dynamic Join condition feature in HANA.

Both will return data based on column at Query execution.

In Dynamic join, alteast a column used in join condition from left or right is mandatory Whereas in Optimal join condition its not the case.

Is there any other key difference or use case to apply these features. It will be very helpful if some one clarifies me on this.

Thanks & Regards,

Divya Kannan

[former_member34]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with our Q&A Tutorial: https://developers.sap.com/tutorials/community-qa.html, as it provides tips for preparing questions that draw responses from our members. Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://www.youtube.com/watch?v=46bt1juWUUM

Many thanks!