Question: a ) [ 3 point ] Let us start by considering a simple nested loop join. Compute the IO cost for a simple nested loop
a point
Let us start by considering a simple nested loop join. Compute the IO cost for a simple
nested loop join if R is the "outer loop" and S is the "inner loop."
b point
Compute the IO cost for a simple nested loop join if S is the "outer loop" and R is the
"inner loop."
c points
Now consider using a block nested loop join. Compute the IO cost for joining R S and then joining the result with T Then compute the IO cost for joining ST and then joining the result with R
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
