PLAN_TABLE_OUTPUT ----------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost | Pstart| Pstop | ----------------------------------------------------------------------------------------------------------- | 0 | INSERT STATEMENT | | 1 | 168 | 1042 | | | | 1 | HASH UNIQUE | | 1 | 168 | 1042 | | | | 2 | FILTER | | | | | | | | 3 | TABLE ACCESS BY LOCAL INDEX ROWID| SRC_FAC_DET | 32120 | 2415K| 1038 | | | | 4 | NESTED LOOPS | | 1 | 168 | 1040 | | | | 5 | TABLE ACCESS FULL | TMP_CCDB_MAP | 1 | 91 | 2 | | | | 6 | PARTITION RANGE SINGLE | | 16060 | | 53 | KEY | KEY | | 7 | INDEX RANGE SCAN | SRC_FAC_DET_IDX6 | 16060 | | 53 | KEY | KEY | | 8 | INDEX UNIQUE SCAN | TMP_MAP_ROWIDS_UK01 | 1 | 38 | 1 | | | ----------------------------------------------------------------------------------------------------------- Note ----- - 'PLAN_TABLE' is old version