Question: ( 1 5 points ) Using two relations R and S , with the join condition R i = S j , and given the
points Using two relations R and S with the join condition and given the following information: Show all your work
M pages in R with pR tuples per page
pages in S with pS tuples per page
R contains:
pages
tuples per page
S contains:
pages
tuples per page
Buffer size is inclusive of additional buffers
a Compute the IO cost for R and S using a block nested loop join for both:
b Compute the IO cost for R and S using a 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
