PLAN_TABLE_OUTPUT Plan hash value: 656983683 -------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | -------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 92 | 0 (0)| 00:00:01 | | 1 | NESTED LOOPS ANTI | | 1 | 92 | 0 (0)| 00:00:01 | | 2 | NESTED LOOPS ANTI | | 1 | 79 | 0 (0)| 00:00:01 | | 3 | TABLE ACCESS BY INDEX ROWID| EMP | 1 | 66 | 0 (0)| 00:00:01 | |* 4 | INDEX UNIQUE SCAN | MY_EMP_ID_PK | 1 | | 0 (0)| 00:00:01 | |* 5 | INDEX RANGE SCAN | EMP_TRANSFERRED_INDX01 | 1 | 13 | 0 (0)| 00:00:01 | |* 6 | INDEX RANGE SCAN | EMP_INACTIVE_INDX01 | 1 | 13 | 0 (0)| 00:00:01 | -------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 4 - access("ID"=105) 5 - access("EMPID"=105) 6 - access("EMPID"=105) Note ----- - dynamic sampling used for this statement (level=2)