Consider a join (relation algebra) between relations \(r(R)\) and \(s(S)\)…
GATE · 2014 · CS · Set 2 · Computer Science & IT
Consider a join (relation algebra) between relations and using the nested loop method. There are 3 buffers each of size equal to disk block size, out of which one buffer is reserved for intermediate results. Assuming , the join will have fewer number of disk block accesses if
- A.
relation
is in the outer loop. - B.
relation
is in the outer loop. - C.
join selection factor between
andis more than 0.5. - D.
join selection factor between
andis less than 0.5.
Attempted by 208 students.
Sign up free to check your answer
Sign up freeLoading lesson…