Question: what are the key differences sort-merge and hash join?
Answer: 2 Answers. A "sort merge" join is performed by sorting the two data sets to be joined according to the join keys and then merging them together. ... A hash join is performed by hashing one data set into memory based on join columns and reading the other one and probing the hash table for matches.