By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
5 rows affected
| STATEMENT_ID | PLAN_ID | TIMESTAMP | REMARKS | OPERATION | OPTIONS | OBJECT_NODE | OBJECT_OWNER | OBJECT_NAME | OBJECT_ALIAS | OBJECT_INSTANCE | OBJECT_TYPE | OPTIMIZER | SEARCH_COLUMNS | ID | PARENT_ID | DEPTH | POSITION | COST | CARDINALITY | BYTES | OTHER_TAG | PARTITION_START | PARTITION_STOP | PARTITION_ID | OTHER | OTHER_XML | DISTRIBUTION | CPU_COST | IO_COST | TEMP_SPACE | ACCESS_PREDICATES | FILTER_PREDICATES | PROJECTION | TIME | QBLOCK_NAME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| partition by contract | 909 | 11-APR-19 | null | SELECT STATEMENT | null | null | null | null | null | null | null | ALL_ROWS | null | 0 | null | 0 | 5 | 5 | 2 | 78 | null | null | null | null | null | null | null | 11290110 | 4 | null | null | null | null | 1 | null |
| partition by contract | 909 | 11-APR-19 | null | VIEW | null | null | FIDDLE_LKGMAVPZZYTILMUSEUHP | null | CTE@SEL$3 | 4 | null | null | null | 1 | 0 | 1 | 1 | 5 | 2 | 78 | null | null | null | null | null | <other_xml><info type="db_version">11.2.0.2</info><info type="parse_schema"><![CDATA["FIDDLE_LKGMAVPZZYTILMUSEUHP"]]></info><info type="dynamic_sampling">2</info><info type="plan_hash">3928127581</info><info type="plan_hash_2">189570273</info><outline_data><hint><![CDATA[USE_NL(@"SEL$58A6D7F6" "COMMISSION"@"SEL$1")]]></hint><hint><![CDATA[LEADING(@"SEL$58A6D7F6" "LOAN"@"SEL$1" "COMMISSION"@"SEL$1")]]></hint><hint><![CDATA[FULL(@"SEL$58A6D7F6" "COMMISSION"@"SEL$1")]]></hint><hint><![CDATA[INDEX(@"SEL$58A6D7F6" "LOAN"@"SEL$1" ("LOAN"."CONTRACT_ID"))]]></hint><hint><![CDATA[NO_ACCESS(@"SEL$3" "CTE"@"SEL$3")]]></hint><hint><![CDATA[OUTLINE(@"SEL$1")]]></hint><hint><![CDATA[OUTLINE(@"SEL$2")]]></hint><hint><![CDATA[OUTLINE_LEAF(@"SEL$3")]]></hint><hint><![CDATA[MERGE(@"SEL$1")]]></hint><hint><![CDATA[OUTLINE_LEAF(@"SEL$58A6D7F6")]]></hint><hint><![CDATA[ALL_ROWS]]></hint><hint><![CDATA[DB_VERSION('11.2.0.2')]]></hint><hint><![CDATA[OPTIMIZER_FEATURES_ENABLE('11.2.0.2')]]></hint><hint><![CDATA[IGNORE_OPTIM_EMBEDDED_HINTS]]></hint></outline_data></other_xml> | null | 11290110 | 4 | null | null | null | "CTE"."ID"[NUMBER,22], "CTE"."VAL"[NUMBER,22], "CTE"."SOMETHING"[NUMBER,22] | 1 | SEL$58A6D7F6 |
| partition by contract | 909 | 11-APR-19 | null | WINDOW | SORT | null | null | null | null | null | null | null | null | 2 | 1 | 2 | 1 | 5 | 2 | 92 | null | null | null | null | null | null | null | 11290110 | 4 | null | null | null | (#keys=2) "LOAN"."CONTRACT_ID"[NUMBER,22], "COMMISSION"."TYPE"[VARCHAR2,10], "LOAN".ROWID[ROWID,10], "COMMISSION"."VALUE"[NUMBER,22], "COMMISSION"."COMMISSION_ID"[NUMBER,22], SUM("COMMISSION"."VALUE") OVER ( PARTITION BY "LOAN"."CONTRACT_ID","COMMISSION"."TYPE")[22], AVG("COMMISSION"."VALUE") OVER ( PARTITION BY "LOAN"."CONTRACT_ID","COMMISSION"."TYPE")[22] | 1 | SEL$58A6D7F6 |
| partition by contract | 909 | 11-APR-19 | null | NESTED LOOPS | null | null | null | null | null | null | null | null | null | 3 | 2 | 3 | 1 | 4 | 2 | 92 | null | null | null | null | null | null | null | 44859 | 4 | null | null | null | (#keys=0) "LOAN".ROWID[ROWID,10], "LOAN"."CONTRACT_ID"[NUMBER,22], "COMMISSION"."COMMISSION_ID"[NUMBER,22], "COMMISSION"."TYPE"[VARCHAR2,10], "COMMISSION"."VALUE"[NUMBER,22] | 1 | null |
| partition by contract | 909 | 11-APR-19 | null | INDEX | UNIQUE SCAN | null | FIDDLE_LKGMAVPZZYTILMUSEUHP | SYS_C00113289 | LOAN@SEL$1 | null | INDEX (UNIQUE) | null | 1 | 4 | 3 | 4 | 1 | 1 | 1 | 13 | null | null | null | null | null | null | null | 8171 | 1 | null | "LOAN"."CONTRACT_ID"=1 | null | "LOAN".ROWID[ROWID,10], "LOAN"."CONTRACT_ID"[NUMBER,22] | 1 | SEL$58A6D7F6 |
| partition by contract | 909 | 11-APR-19 | null | TABLE ACCESS | FULL | null | FIDDLE_LKGMAVPZZYTILMUSEUHP | COMMISSION | COMMISSION@SEL$1 | 2 | TABLE | null | null | 5 | 3 | 4 | 2 | 3 | 2 | 66 | null | null | null | null | null | null | null | 36687 | 3 | null | null | "COMMISSION"."COMMISSION_ID"=1 | "COMMISSION"."COMMISSION_ID"[NUMBER,22], "COMMISSION"."TYPE"[VARCHAR2,10], "COMMISSION"."VALUE"[NUMBER,22] | 1 | SEL$58A6D7F6 |
| partition by other id | 910 | 11-APR-19 | null | SELECT STATEMENT | null | null | null | null | null | null | null | ALL_ROWS | null | 0 | null | 0 | 8 | 8 | 5 | 195 | null | null | null | null | null | null | null | 16942209 | 6 | null | null | null | null | 1 | null |
| partition by other id | 910 | 11-APR-19 | null | VIEW | null | null | FIDDLE_LKGMAVPZZYTILMUSEUHP | null | CTE@SEL$3 | 4 | null | null | null | 1 | 0 | 1 | 1 | 8 | 5 | 195 | null | null | null | null | null | <other_xml><info type="db_version">11.2.0.2</info><info type="parse_schema"><![CDATA["FIDDLE_LKGMAVPZZYTILMUSEUHP"]]></info><info type="dynamic_sampling">2</info><info type="plan_hash">2030380855</info><info type="plan_hash_2">3056054203</info><outline_data><hint><![CDATA[USE_HASH(@"SEL$58A6D7F6" "COMMISSION"@"SEL$1")]]></hint><hint><![CDATA[LEADING(@"SEL$58A6D7F6" "LOAN"@"SEL$1" "COMMISSION"@"SEL$1")]]></hint><hint><![CDATA[FULL(@"SEL$58A6D7F6" "COMMISSION"@"SEL$1")]]></hint><hint><![CDATA[FULL(@"SEL$58A6D7F6" "LOAN"@"SEL$1")]]></hint><hint><![CDATA[NO_ACCESS(@"SEL$3" "CTE"@"SEL$3")]]></hint><hint><![CDATA[OUTLINE(@"SEL$1")]]></hint><hint><![CDATA[OUTLINE(@"SEL$2")]]></hint><hint><![CDATA[OUTLINE_LEAF(@"SEL$3")]]></hint><hint><![CDATA[MERGE(@"SEL$1")]]></hint><hint><![CDATA[OUTLINE_LEAF(@"SEL$58A6D7F6")]]></hint><hint><![CDATA[ALL_ROWS]]></hint><hint><![CDATA[DB_VERSION('11.2.0.2')]]></hint><hint><![CDATA[OPTIMIZER_FEATURES_ENABLE('11.2.0.2')]]></hint><hint><![CDATA[IGNORE_OPTIM_EMBEDDED_HINTS]]></hint></outline_data></other_xml> | null | 16942209 | 6 | null | null | "ID"=1 | "ID"[NUMBER,22], "CTE"."VAL"[NUMBER,22], "CTE"."SOMETHING"[NUMBER,22] | 1 | SEL$58A6D7F6 |
| partition by other id | 910 | 11-APR-19 | null | WINDOW | SORT | null | null | null | null | null | null | null | null | 2 | 1 | 2 | 1 | 8 | 5 | 295 | null | null | null | null | null | null | null | 16942209 | 6 | null | null | null | (#keys=2) "LOAN"."SOME_OTHER_ID"[NUMBER,22], "COMMISSION"."TYPE"[VARCHAR2,10], "LOAN"."CONTRACT_ID"[NUMBER,22], "COMMISSION"."COMMISSION_ID"[NUMBER,22], "COMMISSION"."VALUE"[NUMBER,22], SUM("COMMISSION"."VALUE") OVER ( PARTITION BY "LOAN"."SOME_OTHER_ID","COMMISSION"."TYPE")[22], AVG("COMMISSION"."VALUE") OVER ( PARTITION BY "LOAN"."SOME_OTHER_ID","COMMISSION"."TYPE")[22] | 1 | SEL$58A6D7F6 |
| partition by other id | 910 | 11-APR-19 | null | HASH JOIN | null | null | null | null | null | null | null | null | null | 3 | 2 | 3 | 1 | 7 | 5 | 295 | null | null | null | null | null | null | null | 5696525 | 6 | null | "COMMISSION"."COMMISSION_ID"="LOAN"."CONTRACT_ID" | null | (#keys=1) "LOAN"."CONTRACT_ID"[NUMBER,22], "COMMISSION"."COMMISSION_ID"[NUMBER,22], "LOAN"."SOME_OTHER_ID"[NUMBER,22], "COMMISSION"."VALUE"[NUMBER,22], "COMMISSION"."TYPE"[VARCHAR2,10] | 1 | null |
| partition by other id | 910 | 11-APR-19 | null | TABLE ACCESS | FULL | null | FIDDLE_LKGMAVPZZYTILMUSEUHP | LOAN | LOAN@SEL$1 | 1 | TABLE | null | null | 4 | 3 | 4 | 1 | 3 | 4 | 104 | null | null | null | null | null | null | null | 36287 | 3 | null | null | null | "LOAN"."CONTRACT_ID"[NUMBER,22], "LOAN"."SOME_OTHER_ID"[NUMBER,22] | 1 | SEL$58A6D7F6 |
| partition by other id | 910 | 11-APR-19 | null | TABLE ACCESS | FULL | null | FIDDLE_LKGMAVPZZYTILMUSEUHP | COMMISSION | COMMISSION@SEL$1 | 2 | TABLE | null | null | 5 | 3 | 4 | 2 | 3 | 5 | 165 | null | null | null | null | null | null | null | 36557 | 3 | null | null | null | "COMMISSION"."COMMISSION_ID"[NUMBER,22], "COMMISSION"."TYPE"[VARCHAR2,10], "COMMISSION"."VALUE"[NUMBER,22] | 1 | SEL$58A6D7F6 |