Question: Task 5 : Nested loop join We have a table Student ( Studentno , Name, Birthday, DepartmentNo ) that must be joined with ExamReg (
Task : Nested loop join
We have a table StudentStudentno Name, Birthday, DepartmentNo that must be joined
with ExamRegStudentno Examno, Date, Status Student is stored with records in
blocks and ExamReg is stored with records in 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 blocks available in the buffer, how many blocks are read in total throughout the
join operation?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
