Exam (elaborations)
HW4 Solution University of Michigan EECS 484
- Course
- Institution
Question 1 (20 points) 1.1) (6 points) Block Nested Loops Join (A) Reads = |R| + |S| * ceil(|R|/(B-2)) = 5,000 + 15,000 * ceil(5,000/(800-2)) = 110,000 (B) Writes = 0 (no writes are required for nested loops joins) 1.2) (7 points) Grace Hash Join (A) Reads in Partition phase = |R| + |S| = 20...
[Show more]