In a merge-scan join ____.
A) neither of the two join attributes has to be in sorted order or has to have an index built over it
B) one of the two join attributes either has to be in sorted order or has to have an index built over it
C) both of the join attributes have to be in sorted order or have to have indexes built over them
D) the only requirement is that every row of one table is compared against every row of the other table looking for a match on the join attributes.
E) None of the above.

Question

Quizplus · Accepted Answer

In a merge-scan join, both join attributes must be sorted or have indexes to efficiently merge and scan through them.

In a Merge-Scan Join ____