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:
As in section 18.2.3 we assume the secondary index on MGRSSN of DEPARTMENT, with selection cardinality s=1 and level x=1
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
As in section 18.2.3 we assume the secondary index on MGRSSN of DEPARTMENT, with selection cardinality s=1 and level x=1
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!