STATEMENT_ID TIMESTAMP REMARKS OPERATION OPTIONS OBJECT_NODE OBJECT_OWNER OBJECT_NAME OBJECT_INSTANCE OBJECT_TYPE OPTIMIZER SEARCH_COLUMNS ID PARENT_ID POSITION COST CARDINALITY BYTES OTHER_TAG PARTITION_START PARTITION_STOP PARTITION_ID OTHER DISTRIBUTION testting 22/07/2009 11:36:25 INSERT STATEMENT CHOOSE 0 1478 1478 1 154 testting 22/07/2009 11:36:25 HASH UNIQUE 1 0 1 1478 1 154 testting 22/07/2009 11:36:25 FILTER 2 1 1 testting 22/07/2009 11:36:25 TABLE ACCESS BY LOCAL INDEX ROWID CRES2PROD SRC_FAC_DET 2 TABLE ANALYZED 3 2 1 1474 46096 2904048 testting 22/07/2009 11:36:25 NESTED LOOPS 4 3 1 1476 1 154 testting 22/07/2009 11:36:25 TABLE ACCESS FULL CRES2PROD TMP_CCDB_MAP 3 TABLE (TEMP) 5 4 1 2 1 91 testting 22/07/2009 11:36:25 PARTITION RANGE SINGLE 6 4 2 77 23048 KEY KEY 6 testting 22/07/2009 11:36:25 INDEX RANGE SCAN CRES2PROD SRC_FAC_DET_IDX6 INDEX ANALYZED 1 7 6 1 77 23048 KEY KEY 6 testting 22/07/2009 11:36:25 INDEX UNIQUE SCAN CRES2PROD TMP_MAP_ROWIDS_UK01 INDEX (UNIQUE) 4 8 2 2 1 1 38