Question: 4 . Assume we use an index - join with R 2 as the outer relation, and we have an index on R 1 .
Assume we use an indexjoin with R as the outer relation, and we have an index on Ra Assume that the index fits in memory. Moreover, on average we get R tuples matching every R tuple.
a What is the cost of the join algorithm?
Here you might need to make assumptions ie one or both tables are clustered or not or index is clustered or not, index in memory or not, etc.
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
