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 CPU_COST IO_COST TEMP_SPACE ACCESS_PREDICATES FILTER_PREDICATES sid_1 17:22.0 [NULL] SELECT STATEMENT [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] CHOOSE [NULL] 0 [NULL] 5183 5183 78 62244 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 5183 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] COUNT STOPKEY [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 1 0 1 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] ROWNUM=1 sid_1 17:22.0 [NULL] FILTER [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 2 1 1 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] :B1=:B2 sid_1 17:22.0 [NULL] TABLE ACCESS BY INDEX ROWID [NULL] PRSTRAIN T_CNTRY 1 [NULL] ANALYZED [NULL] 3 2 1 1 1 28 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 1 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] INDEX UNIQUE SCAN [NULL] PRSTRAIN PK_T_CNTRY [NULL] UNIQUE ANALYZED 1 4 3 1 [NULL] 1 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] TC1."CNTRY_ID"=:B1 [NULL] sid_1 17:22.0 [NULL] COUNT STOPKEY [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 5 0 2 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] ROWNUM=1 sid_1 17:22.0 [NULL] FILTER [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 6 5 1 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] :B1=:B2 sid_1 17:22.0 [NULL] TABLE ACCESS BY INDEX ROWID [NULL] PRSTRAIN T_CNTRY 2 [NULL] ANALYZED [NULL] 7 6 1 1 1 28 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 1 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] INDEX UNIQUE SCAN [NULL] PRSTRAIN PK_T_CNTRY [NULL] UNIQUE ANALYZED 1 8 7 1 [NULL] 1 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] TC2."CNTRY_ID"=:B1 [NULL] sid_1 17:22.0 [NULL] FILTER [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 9 0 3 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] NOT EXISTS (SELECT /*+ */ 0 FROM "T_EMD_ERR_Q_RULES" "T_EMD_ERR_Q_RULES" WHERE "T_EMD_ERR_Q_RULES"."CNTRY_ID"=:B1 AND "T_EMD_ERR_Q_RULES"."ASSET_TYP_CD"=:B2 AND "T_EMD_ERR_Q_RULES"."CNTRY_QUOTE"=:B3) sid_1 17:22.0 [NULL] HASH JOIN OUTER [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 10 9 1 5105 78 62244 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 5105 [NULL] SYS_ALIAS_9."ASSET_ID"="T_ASSET_ASSET_REL_B"."REL_ASSET_ID"(+) [NULL] sid_1 17:22.0 [NULL] HASH JOIN OUTER [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 11 10 1 5099 78 61308 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 5099 [NULL] SYS_ALIAS_9."ASSET_ID"="T_ASSET_ASSET_REL_A"."ASSET_ID"(+) [NULL] sid_1 17:22.0 [NULL] HASH JOIN [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 12 11 1 5093 78 60372 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 5093 [NULL] TAT."ASSET_TYP_CD"="SYS_ALIAS_9"."ASSET_TYP_CD" [NULL] sid_1 17:22.0 [NULL] TABLE ACCESS FULL [NULL] PRSTRAIN T_ASSET_TYP 18 [NULL] ANALYZED [NULL] 13 12 1 2 36 1116 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 2 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] HASH JOIN [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 14 12 2 5090 78 57954 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 5090 [NULL] EG."EXCH_GRP_ID"="MKT"."EXCH_GRP_ID" [NULL] sid_1 17:22.0 [NULL] TABLE ACCESS FULL [NULL] PRSTRAIN T_EXCH_GRP 17 [NULL] ANALYZED [NULL] 15 14 1 2 21 609 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 2 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] FILTER [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 16 14 2 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] TAE."ASSET_EXT_ID_SYS_CD"=NVL("ATC"."SECNDR_ASSET_ID_TYP_CD",' ') OR "TAE"."ASSET_EXT_ID_SYS_CD"=NVL("ATC"."SECNDR_ASSET_ID_TYP_CD",' ') sid_1 17:22.0 [NULL] HASH JOIN OUTER [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 17 16 1 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] SYS_ALIAS_9."CNTRY_QUOTE"="ATC"."CNTRY_ID"(+) AND "SYS_ALIAS_9"."ASSET_TYP_CD"="ATC"."ASSET_TYP_CD"(+) [NULL] sid_1 17:22.0 [NULL] HASH JOIN [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 18 17 1 5084 78 54288 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 5084 1663000 BGC."BUS_GRP"="TU"."BUS_GRP" AND "SYS_ALIAS_9"."CNTRY_QUOTE"="BGC"."CNTRY_ID" AND "SYS_ALIAS_9"."ASSET_TYP_CD"="BGC"."ASSET_TYP_CD" AND "BGC"."EXCH_ID"="SYS_ALIAS_5"."EXCH_ID" [NULL] sid_1 17:22.0 [NULL] NESTED LOOPS [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 19 18 1 4881 2394 1630314 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 4881 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] HASH JOIN [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 20 19 1 93 2394 349524 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 93 [NULL] MKT."EXCH_ID"="SYS_ALIAS_5"."EXCH_ID" [NULL] sid_1 17:22.0 [NULL] TABLE ACCESS FULL [NULL] PRSTRAIN T_EXCH_MKT 16 [NULL] ANALYZED [NULL] 21 20 1 2 241 4097 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 2 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] HASH JOIN [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 22 20 2 90 2394 308826 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 90 [NULL] SYS_ALIAS_5."REASON"="TRT"."REASON_TYP_CD" [NULL] sid_1 17:22.0 [NULL] TABLE ACCESS FULL [NULL] PRSTRAIN T_REASON_TYP 11 [NULL] ANALYZED [NULL] 23 22 1 2 6 150 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 2 [NULL] [NULL] TRT."REASON_TYP_TYPE"='E' sid_1 17:22.0 [NULL] HASH JOIN [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 24 22 2 87 2793 290472 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 87 [NULL] PTG."PRICING_PT_ID"="SYS_ALIAS_5"."PRICING_PT_ID" [NULL] sid_1 17:22.0 [NULL] NESTED LOOPS [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 25 24 1 5 4 196 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 5 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] NESTED LOOPS [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 26 25 1 4 1 42 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 4 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] TABLE ACCESS BY INDEX ROWID [NULL] PRSTRAIN T_USER 13 [NULL] ANALYZED [NULL] 27 26 1 2 1 30 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 2 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] INDEX UNIQUE SCAN [NULL] PRSTRAIN PK_T_USER [NULL] UNIQUE ANALYZED 1 28 27 1 1 1 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 1 [NULL] TU."USER_ID"=2021 [NULL] sid_1 17:22.0 [NULL] TABLE ACCESS FULL [NULL] PRSTRAIN T_ASSET_EXT_ID_SYS 15 [NULL] ANALYZED [NULL] 29 26 2 2 1 12 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 2 [NULL] [NULL] TAE."USAGE_FLG"='Y' sid_1 17:22.0 [NULL] INDEX RANGE SCAN [NULL] PRSTRAIN SYS_C0026105 [NULL] UNIQUE ANALYZED 1 30 25 2 1 19 133 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 1 [NULL] TU."PRICING_PT_GRP_ID"="PTG"."PRICING_PT_GRP_ID" [NULL] sid_1 17:22.0 [NULL] TABLE ACCESS FULL [NULL] PRSTRAIN T_PRC_ERR_Q 3 [NULL] ANALYZED [NULL] 31 24 2 81 60494 3327170 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 81 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] TABLE ACCESS BY INDEX ROWID [NULL] PRSTRAIN T_ASSET 4 [NULL] ANALYZED [NULL] 32 19 2 2 1 535 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 2 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] INDEX UNIQUE SCAN [NULL] PRSTRAIN PK_T_ASSET [NULL] UNIQUE ANALYZED 1 33 32 1 1 1 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 1 [NULL] SYS_ALIAS_5."ASSET_ID"="SYS_ALIAS_9"."ASSET_ID" [NULL] sid_1 17:22.0 [NULL] INDEX FAST FULL SCAN [NULL] PRSTRAIN I_T_BUS_GRP_CNTRY [NULL] UNIQUE ANALYZED [NULL] 34 18 2 99 189503 2842545 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 99 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] TABLE ACCESS BY INDEX ROWID [NULL] PRSTRAIN T_ASSET_TYP_CNTRY 5 [NULL] ANALYZED [NULL] 35 17 2 2 1 18 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 2 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] INDEX RANGE SCAN [NULL] PRSTRAIN ASSETID [NULL] NON-UNIQUE ANALYZED 1 36 35 1 1 1 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 1 [NULL] ATC."ASSET_ID"(+)=(-1) [NULL] sid_1 17:22.0 [NULL] INDEX FAST FULL SCAN [NULL] PRSTRAIN PK_T_ASSET_ASSET_REL [NULL] UNIQUE ANALYZED [NULL] 37 11 2 5 5066 60792 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 5 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] INDEX FAST FULL SCAN [NULL] PRSTRAIN PK_T_ASSET_ASSET_REL [NULL] UNIQUE ANALYZED [NULL] 38 10 2 5 5066 60792 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] 5 [NULL] [NULL] [NULL] sid_1 17:22.0 [NULL] INDEX UNIQUE SCAN [NULL] PRSTRAIN PK_T_EMD_ERR_Q_RULES [NULL] UNIQUE ANALYZED 3 39 9 2 [NULL] 1 39 [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] [NULL] T_EMD_ERR_Q_RULES."CNTRY_QUOTE"=:B1 AND "T_EMD_ERR_Q_RULES"."ASSET_TYP_CD"=:B2 AND "T_EMD_ERR_Q_RULES"."CNTRY_ID"=:B3 [NULL]