Optimize Join in SAP HANA

Поделиться
HTML-код
  • Опубликовано: 24 дек 2024

Комментарии • 16

  • @NaveenKumar-dg2pg
    @NaveenKumar-dg2pg 4 года назад +2

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

  • @aparna05m
    @aparna05m 4 года назад +1

    You are the best sir.

  • @barnalikar7498
    @barnalikar7498 4 года назад +2

    Nicely explained.. thanks for sharing

  • @kumarchandrahas1462
    @kumarchandrahas1462 3 года назад

    Very nice and exact explanation

  • @vijayanandp8804
    @vijayanandp8804 4 года назад

    Very useful info, thank you.

  • @vivekkhirid108
    @vivekkhirid108 3 года назад

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

  • @phaniindra1936
    @phaniindra1936 3 года назад

    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.

  • @altamashkhan5009
    @altamashkhan5009 3 года назад

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

    • @Zweny88
      @Zweny88 3 года назад

      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
      @vivekkhirid108 3 года назад

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

  • @shwetamittal7552
    @shwetamittal7552 4 года назад

    Any plans to Start Native hana course

    • @DebanshuMukherjee
      @DebanshuMukherjee  4 года назад +1

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

  • @vnani5791
    @vnani5791 4 года назад

    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

  • @mukteshmandal5689
    @mukteshmandal5689 4 года назад +3

    Deb is Hana Guru