Question: Using two relations R and S , with the join condition Ri = Sj , and given the following information: ( Show all your work
Using two relations R and S with the join condition RiSj and given the
following information: Show all your work
M pages in R with pR tuples per page
N 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:
RS
SR
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
