Optimizer can choose a sort merge join over a hash join for joining large amounts of data and if join condition between two tables is not an equi-join. In this method both the inputs are sorted on the join key and then sorted lists are merged together.