Question: 2. Suppose we compute the nested-loop join of two relations, one of which occupies 2000 blocks and the other occupies 500 blocks. There are 40

 2. Suppose we compute the nested-loop join of two relations, one

2. Suppose we compute the nested-loop join of two relations, one of which occupies 2000 blocks and the other occupies 500 blocks. There are 40 main-memory buffers available to hold blocks of one of these two relations. How many disk blocks must be read to compute their nested-loop join? Note that we do not count the space or disk I/O's needed to accumulate or write the tuples of the result. a) 26,142 b) 28,000 c) 26,500 d) 25,500

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 Databases Questions!