Question
Suppose the operation is EMP LOY EE ./ SSN=ESSN WORKSON, and we are using J1, the nested-loop join approach. Further suppose that the buffer size
Suppose the operation is EMP LOY EE
./ SSN=ESSN WORKSON, and we are using J1, the nested-loop join approach. Further suppose that the buffer size nB = 7, the
EMPLOY EE file has 20,000 records in 2000 blocks, and the WORKSON file has 10,000 records in 500 blocks
Calculate the number of disk accesses if
i. EMPLOY EE is the outer relation.
ii. WORKSON is the outer relation.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Conceptual Database Design An Entity Relationship Approach
Authors: Carol Batini, Stefano Ceri, Shamkant B. Navathe
1st Edition
0805302441, 978-0805302448
