MSJOIN
Short Description
The MSJOIN represents a merge join
Detailed Description​
The MSJOIN represents a merge join, also known as sorted merge join or a merge scan join. This operator is required by queries that reference more than one table in the FROM clause.
A merge join requires sorted input on the joining columns. This input is gained from either an index or a sorted table.
Performance can be improved by using local predicates i.e. predicates that reference only one of the tables in the join to minimize the number of rows being joined.
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.