Sort-Merge Join is an efficient algorithm used in database management systems to combine rows from two sorted relations based on a common attribute. It is particularly effective when both inputs are already sorted, as it minimizes the need for additional sorting and can handle large datasets efficiently by leveraging sequential disk access.