Question Let relations r1(A, B, C) and r2(C, D, E) have the following properties: r1 has20,000 tuples, r2 has 45,000 tuples, 25 tuples of r1 fit on one block, and 30tuples of r2 fit on one block. Estimate the number of block transfers and seeksrequired using each of the following join strategies for r1 ⋈ r2: Block nested-loop join.

WONQD3 The Asker · Computer Science

Let relations r1(A, B, C) and r2(C, D, E) have the following properties: r1 has
20,000 tuples, r2 has 45,000 tuples, 25 tuples of r1 fit on one block, and 30
tuples of r2 fit on one block. Estimate the number of block transfers and seeks
required using each of the following join strategies for r1 ⋈ r2: Block nested-loop join.

More