Derive the time cost of a block nested loops join of relations R and S given the following variables, which you may or may not use all of them. Ignore the CPU time costs. R is the outer relation and the results of the join are written back to the disk.

BLOCK NESTED LOOP JOIN

WORST CASE:

=br ∗ bs + br block transfers + 2 * br seeks = (M*N*Cr)/(B-2)+|R|*|S|+P*Cw

br=no of blocks or pages containging relation r

Explanation:

The block nested loop is used to join the of relations R and S given that these following variables, we may or may not use all of them.

BLOCK NESTED LOOP JOIN

WORST CASE:

=br ∗ bs + br block transfers + 2 * br seeks = (M*N*Cr)/(B-2)+|R|*|S|+P*Cw

br=no of blocks or pages containging relation r