[The \*Right\* Way to do Batch Job Data Joins \| Systems Design Interview 0 to 1 with Ex-Google SWE - YouTube](https://www.youtube.com/watch?v=gqxbQTVgdkI&list=PLjTveVh7FakLdTmm42TMxbN8PvVn5g4KJ&index=40) # Types of Joins ## Sort Merge Joins - Can always be used. The merging can be done entirely on disk. - Very slow - takes a long time to sort - Also, have to send at least one of the datasets over the network ## Broadcast Hash Joins ## Partitioned Hash Joins