OPERATION OPTIONS OBJECT_NAME ID PARENT_ID POSITION -------------------- --------- -------------------- -- ------ -------- SELECT STATEMENT 0 0 NESTED LOOPS 1 0 1 NESTED LOOPS 2 1 1 TABLE ACCESS BY INDEX ROWI EMPLOYEES 3 2 1 INDEX UNIQUE SCAN EMP_EMP_ID_PK 4 3 1 TABLE ACCESS BY INDEX ROWI DEPARTMENTS 5 2 2 INDEX UNIQUE SCAN DEPT_ID_PK 6 5 1 TABLE ACCESS BY INDEX ROWID LOCATIONS 7 1 2 INDEX UNIQUE SCAN LOC_ID_PK 8 7 1 9 rows selected.