As in section 18.2.3 we assume the secondary index on MGRSSN of DEPARTMENT, with selection cardinality s=1 and level x=1
Posted: Mon Jun 06, 2022 5:05 pm
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:
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: