14.412 Simple Hash Join

[@Fishman1049]

These videos are great. Thank you for sharing them to people outside your classrooms!

[@jensdit]

+Fishman1049 thanks! My book which was written around those videos just appeared: www.amazon.com/Patterns-Data-Management-Flipped-Textbook-ebook/dp/B01BEXUYMK

[@ChristopherNemoNakamura]

You're getting me through this class man.

[@jorgerivera2260]

Hi Professor Jens, please could you tell me what application you use to create your video?? I want to do a webinar using slides and drawing on them.

[@jessiema9477]

very clear and good explanation about Hash Join but why no visual illustration like the video for sort-merge join...?

[@jensdit]

thanks; yes, that would be a nice extension for this video to show a visual example as well; on the other hand, especially hash joins are recapped multiple times throughout this course - providing different views/explanations on the algorithm. For instance, just to show the impact of blocking when using hash joins in a query plan is explained in video 14.528:
v=SR4AaqA4DXY
Is that video visual enough? ;-)
There I also recap that SHJ is basically a bulkload (tuple-wise or better) of an index followed by a loop (with probe) over the other input.

[@jessiema9477]

OMG thank you for giving more information...actually I ran into your video when searching for illustrations on the join methods and now thanks to your help I can go into the exam hall 3 hours later;)

[@baravi2005]

Awesome lectures! Thanks so much for sharing :)

[@MrDh0797]

try to find how to roll hash joint lol

[@jensdit]

dl.acm.org/citation.cfm?id=335393

[@yorth8154]

Nooo wayyyy