Calculate the cost of functions for different options of executing the JOIN operation OP7. OP7: DEPARTMENT |x| MGRSSN=SS
Posted: Mon Jun 06, 2022 5:47 pm
Calculate the cost of functions for different options of
executing the JOIN operation OP7.
OP7: DEPARTMENT |x| MGRSSN=SSN EMPLOYEE
We assume the secondary index on MGRSSN of DEPARTMENT, with
selection cardinality s=1 and level x=1.
J2 with EMPLOYEE as outer loop, and MGRSSN as secondary key for
S(index-based nested-loop join):
Please add the mgrssn as the secondary key to the
formula and solve. Thank you.
executing the JOIN operation OP7.
OP7: DEPARTMENT |x| MGRSSN=SSN EMPLOYEE
We assume the secondary index on MGRSSN of DEPARTMENT, with
selection cardinality s=1 and level x=1.
J2 with EMPLOYEE as outer loop, and MGRSSN as secondary key for
S(index-based nested-loop join):
Please add the mgrssn as the secondary key to the
formula and solve. Thank you.