Advanced Database Management Exercises Ch. 19 Pg. 740 19.18 - Calculate the cost of functions for different options of e
Posted: Mon Jun 06, 2022 5:09 pm
Advanced Database Management
Exercises Ch. 19 Pg. 740
19.18 - Calculate the cost of functions
for different options of executing the JOIN operation OP7 discussed
in section 19.4.
OP7 DEPARTMENT |x| MGRSSN=SSN EMPLOYEE.
Hints: Refer to figure 5.5 pg. 161
19.5.2 Examples Pg 721
As in section 18.2.3 we assume the secondary index on MGRSSN of
DEPARTMENT, with selection cardinality s=1 and level x=1;
Using Method J1 with EMPLOYEE as outer loop:
J1 with DEPARTMENT as outer loop:
J2 with EMPLOYEE as outer loop, and MGRSSN as secondary key for
S:
J2 with DEPARTMENT as outer loop:
Exercises Ch. 19 Pg. 740
19.18 - Calculate the cost of functions
for different options of executing the JOIN operation OP7 discussed
in section 19.4.
OP7 DEPARTMENT |x| MGRSSN=SSN EMPLOYEE.
Hints: Refer to figure 5.5 pg. 161
19.5.2 Examples Pg 721
As in section 18.2.3 we assume the secondary index on MGRSSN of
DEPARTMENT, with selection cardinality s=1 and level x=1;
Using Method J1 with EMPLOYEE as outer loop:
J1 with DEPARTMENT as outer loop:
J2 with EMPLOYEE as outer loop, and MGRSSN as secondary key for
S:
J2 with DEPARTMENT as outer loop: