Why we use option (merge join)
Why we use option (merge join) in Sql server ????
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Oct 16, 2013, 3:41 AM
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.