Sorting is necessary for merge Join

Why sorting is necessary for Merge Join?

Principal of merge Join is that it checks the data row by row depending on given key field.If data is not sorted then it might produce improper output.

1 Like