Consider a join (relation algebra) between relations \(r(R)\) and \(s(S)\)…
PYQ GATE 2014
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 261 students.
Sign up free to check your answer
Sign up freeLoading lesson…

