Why we use option (merge join)

Question

Why we use option (merge join) in Sql server ????

Jignesh Trivedi · Answer

hi The merge join provides an output that is generated from joining two sorted data set using a FULL LEFT or INNER join. and it required both input sorted and joined column must matching meta data (including datatype). the mege join itseft very fast. As per my knowledge you can apply merge join to presorted table of similar size. Please refer http://www.mssqltips.com/sqlservertip/2917/sql-server-join-hints/ hope this will help you.