MS SQL Server Joins Question: Download SQL Server Joins PDF

What is Merge join?

Tweet Share WhatsApp

Answer:

Merge join If both join relations come in order, sorted by the join attribute(s), the system can perform the join trivially, thus: It can consider the current group of tuples from the inner relation which consists of a set of contiguous tuples in the inner relation with the same value in the join attribute. For each matching tuple in the current inner group, add a tuple to the join result. Once the inner group has been exhausted, advance both the inner and outer scans to the next group.

Download SQL Server Joins PDF Read All 49 SQL Server Joins Questions
Previous QuestionNext Question
Explain Nested Join?What is Hash join?