Merge Join Internals in SQL Server

Ғылым және технология

Without additional optimizations, SQL Server's Merge Join algorithm is the fastest physical join operator available. In this episode we dive into the internals to understand how the merge join algorithm works, as well as what it means for our query performance.
Subscribe and turn on notifications to never miss a weekly video: kzread.info...
Related blog post about Merge Joins:
bertwagner.com/2018/12/18/vis...
Be sure to check out part 1 on nested loops joins: • The Importance of Nest...
And part 3 on hash match joins: • Hash Match Join Intern...
The pessimistic costing of merge joins:
dba.stackexchange.com/questio...
Going further in-depth with merge joins:
sqlserverfast.com/epr/merge-j...
Follow me on Twitter:
/ bertwagner

Пікірлер: 15

  • @VicFroman
    @VicFroman4 жыл бұрын

    The you. I have worked with SQL for 20 years and developed in them for 5ish and have never been able to understand execution plans. This was very well explained

  • @zanonilabuschagne7628
    @zanonilabuschagne76285 жыл бұрын

    Thanks for this one Bert. This "series" on join internals is really useful!! p.s. Have a great festive period !!

  • @thomasmiller8289
    @thomasmiller82895 жыл бұрын

    Wow, this is great, instant subscribe for this series!

  • @tuval012
    @tuval0123 жыл бұрын

    Thank you! Good explanation

  • @Das.Kleine.Krokodil
    @Das.Kleine.Krokodil4 жыл бұрын

    Очень доходчиво, спасибо!

  • @jeffh6846
    @jeffh68465 жыл бұрын

    How would it work if you put a many to one relationship where the duplicate is in the first input but not in the second?

  • @janasoliman9773
    @janasoliman97738 ай бұрын

    Thank you that was so useful!

  • @andrew5407
    @andrew54074 жыл бұрын

    Excellent

  • @user-vg7jz1sz5k
    @user-vg7jz1sz5k4 ай бұрын

    what is sound track plays?

  • @user-od5ny6rv9n
    @user-od5ny6rv9nАй бұрын

    Thanks🎉

  • @AmritanshDiwakar
    @AmritanshDiwakar4 жыл бұрын

    How can I create a scenario for the optimizer to select merge join? can anyone please tell. I have already tried the below scenario: --> 2 tables with 7 lakh records each --> both tables have clustered index on the joined column

  • @ahadbutt7481
    @ahadbutt74814 жыл бұрын

    Love your videos! What background music are you using btw?

  • @rajkumar-oy3ni
    @rajkumar-oy3ni3 ай бұрын

    your content and explanation is good but for further videos can you please remove background music, difficult focus on what you said

  • @tsunningwah3471
    @tsunningwah34713 ай бұрын

    可能，你，那麼，那麼，那麼，那麼，你，嗎你們，你，m

Келесі