Question: Task 5 : Nested loop join We have a table Student ( Studentno , Name, Birthday, DepartmentNo ) that must be joined with ExamReg (

Task 5: Nested loop join
We have a table Student(Studentno, Name, Birthday, DepartmentNo) that must be joined
with ExamReg(Studentno, Examno, Date, Status). Student is stored with 47000 records in
800 blocks and ExamReg is stored with 500000 records in 12800 blocks. We wish to use
nested for loop join, meaning that we for each block in one of the tables compare and check
whether Studentno is equal.
If we have 34 blocks available in the buffer, how many blocks are read in total throughout the
join operation?
Task 5 : Nested loop join We have a table Student

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!