Question: 4 . ( 1 0 pts ) Let relations r 1 ( A , B , C ) and r 2 ( C , D
pts Let relations rA B C and rC D E have the following properties: r has tuples, r has tuples, tuples of r fit on one block, and tuples of r fit on one block. Estimate the number of block transfers and seeks required using each of the following join strategies for r Join r:
A Merge join
B Hash join
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
