0
7.7kviews
Explain sort-merge join algorithm in query processing.

Mumbai University > Computer Engineering > Sem 4 > Database Management System

Marks: 10M

Year: Dec 2014, May 2014

1 Answer
0
154views
  • If the records of R and S are physically sorted by value of the join attributes AandB, respectively, the join can be implemented in the most efficient way possible.
  • Both files are scanned concurrently in order of the join attributes, matching the records that have the same values for A …

Create a free account to keep reading this post.

and 4 others joined a min ago.

Please log in to add an answer.