Question: 4 . Assume we use an index - join with R 2 as the outer relation, and we have an index on R 1 .

4. Assume we use an index-join with R2 as the outer relation, and we have an index on R1.a. Assume that the index fits in memory. Moreover, on average we get 5 R1 tuples matching every R2 tuple.
a. What is the cost of the join algorithm?
Here you might need to make assumptions i.e. one or both tables are clustered (or not), or index is clustered or not, index in memory or not, etc.
4 . Assume we use an index - join with R 2 as the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!