in Databases
431 views
1 vote
1 vote

in Databases
431 views

1 Answer

0 votes
0 votes
No of blocks for R = $100$ blocks

No of blocks for S = $25$ blocks

Block nested loop join :

Keeping R as outer = $100+100 \times 25=2600$ Access
Keeping S as outer = $25 + 25 \times 100 =2525$ Access

Min$(2600,2525)=2525$ (Keeping S as outer)

Related questions