429 views

1 Answer

0 votes
0 votes

T1 has 4000 records 50 disk blocks

T2 has 300 records 20 disk blocks

Nested loop join condition block access required 300*50+20=15020

https://gateoverflow.in/3847/gate2005-it-82a

edited by

Related questions

0 votes
0 votes
0 answers
1
0 votes
0 votes
1 answer
2
bhucho asked Sep 13, 2023
259 views
please can someone help with part (a) of this question.
0 votes
0 votes
1 answer
3
chinmay_rajpurohit asked Mar 2, 2023
642 views
2NF , 3NF, BCNF decomposition allowed if lossless and dependency preserving , both conditions must preserve. Otherwise given decomposition wrong for normal forms. Is this...