What is (are) the difference between Lookup, Join and Merge
Memory usage
Sorting
Treatment of rows with unmatched keys
All the above