logo

Crowdly

Consider relations R(A,B,C) and S(C,D,E). R has 20,000 tuples and S has 45,000 t...

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Consider relations R(A,B,C) and S(C,D,E). R has 20,000 tuples and S has 45,000 tuples. 25 tuples of R fit on one block, and 30 tuples of S fit on one block. Further, S.C is the primary key in relation S, and there is clustering B+tree index on S.C with height 4. How many block transfer would an index nested loop join incur?

More questions like this

Want instant access to all verified answers on moodlenew.iitd.ac.in?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!