Suppose you are given the following information: R S B(R) = 2500 B(S)=20 T(R) 50000 T(S)...

 

Transcribed Image Text:

Suppose you are given the following information: R S B(R) = 2500 B(S)=20 T(R) 50000 T(S) = 500 = V(R, x)=300 V(R, y)=50 y= [20, 1000] 2.1 Compute the following. What is the cost of joining R and S using a hash join. Assume M = 22. Show your work. 2.2 What is the cost of a nested loop join between R and S? How much memory is required? 2.3 What is the cost of <200(R) Suppose you are given the following information: R S B(R) = 2500 B(S)=20 T(R) 50000 T(S) = 500 = V(R, x)=300 V(R, y)=50 y= [20, 1000] 2.1 Compute the following. What is the cost of joining R and S using a hash join. Assume M = 22. Show your work. 2.2 What is the cost of a nested loop join between R and S? How much memory is required? 2.3 What is the cost of <200(R)