Optimize Join in SAP HANA

[@NaveenKumar-dg2pg]

Thanks Sir.... Nice & Informative video.....

[@aparna05m]

You are the best sir.

[@barnalikar7498]

Nicely explained.. thanks for sharing

[@DebanshuMukherjee]

Thanks Barnali !

[@phaniindra1936]

Sir if you take bottom left side take aggregation node and keep any key figure as Sum or Max . Still the result as same like optimization join.

[@vivekkhirid108]

I am more confused now. In this case dynamic join will also help right?

[@mukteshmandal5689]

Deb is Hana Guru

[@kumarchandrahas1462]

Very nice and exact explanation

[@vijayanandp8804]

Very useful info, thank you.

[@altamashkhan5009]

Is it mandatory to know the cardinality while selecting optimize join option.

[@Zweny88]

Do you know why i don't see this flag ? We have hana 2.0 and i wonder if this flag has been removed?

[@vivekkhirid108]

@@Zweny88 Its not available as flag but as True or False in 2.0

[@vnani5791]

I need some help from M_SQL_Plan_cache sir. I need to know about the statement_ string functionality. Mainly we know about the consolidated the valid statement strings and compare the load and execution time and memory as well. Please ping me sir. I need your suggestions

[@shwetamittal7552]

Any plans to Start Native hana course

[@DebanshuMukherjee]

Hi Shweta...it's work in progress...will lauch it soon.