By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
15 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
null | 1003 | 08-OCT-19 | null | SELECT STATEMENT | null | null | null | null | null | null | null | ALL_ROWS | null | 0 | null | 0 | 4 | 4 | 15 | 105 | null | null | null | null | null | null | null | 11278537 | 3 | null | null | null | null | 1 | null |
null | 1003 | 08-OCT-19 | null | FILTER | null | null | null | null | null | null | null | null | null | 1 | 0 | 1 | 1 | null | null | null | null | null | null | null | null | <other_xml><info type="db_version">11.2.0.2</info><info type="parse_schema"><![CDATA["FIDDLE_JIQQBFMHCVVQRJYBBOOG"]]></info><info type="dynamic_sampling">2</info><info type="plan_hash">426093404</info><info type="plan_hash_2">3737875932</info><outline_data><hint><![CDATA[USE_HASH_AGGREGATION(@"SEL$1")]]></hint><hint><![CDATA[FULL(@"SEL$1" "P"@"SEL$1")]]></hint><hint><![CDATA[OUTLINE_LEAF(@"SEL$1")]]></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 | null | null | null | null | COUNT(SUBSTR("P"."RECEIPTNO",1,3))>=10 | COUNT(SUBSTR("P"."RECEIPTNO",1,3))[22] | null | SEL$1 |
null | 1003 | 08-OCT-19 | null | HASH | GROUP BY | null | null | null | null | null | null | null | null | 2 | 1 | 2 | 1 | 4 | 15 | 105 | null | null | null | null | null | null | null | 11278537 | 3 | null | null | null | (#keys=1) SUBSTR("P"."RECEIPTNO",1,3)[12], COUNT(SUBSTR("P"."RECEIPTNO",1,3))[22] | 1 | null |
null | 1003 | 08-OCT-19 | null | TABLE ACCESS | FULL | null | FIDDLE_JIQQBFMHCVVQRJYBBOOG | PURCHASE | P@SEL$1 | 1 | TABLE | null | null | 3 | 2 | 3 | 1 | 3 | 15 | 105 | null | null | null | null | null | null | null | 30736 | 3 | null | null | null | "P"."RECEIPTNO"[VARCHAR2,10] | 1 | SEL$1 |
4 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
null | 1004 | 08-OCT-19 | null | SELECT STATEMENT | null | null | null | null | null | null | null | ALL_ROWS | null | 0 | null | 0 | 1 | 1 | 15 | 120 | null | null | null | null | null | null | null | 10121 | 1 | null | null | null | null | 1 | null |
null | 1004 | 08-OCT-19 | null | FILTER | null | null | null | null | null | null | null | null | null | 1 | 0 | 1 | 1 | null | null | null | null | null | null | null | null | <other_xml><info type="db_version">11.2.0.2</info><info type="parse_schema"><![CDATA["FIDDLE_JIQQBFMHCVVQRJYBBOOG"]]></info><info type="dynamic_sampling">2</info><info type="plan_hash">2477607880</info><info type="plan_hash_2">2683090441</info><outline_data><hint><![CDATA[INDEX(@"SEL$1" "P"@"SEL$1" "IX_PURCHASE_1")]]></hint><hint><![CDATA[OUTLINE_LEAF(@"SEL$1")]]></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 | null | null | null | null | COUNT(SUBSTR("RECEIPTNO",1,3))>=10 | COUNT(SUBSTR("RECEIPTNO",1,3))[22] | null | SEL$1 |
null | 1004 | 08-OCT-19 | null | SORT | GROUP BY NOSORT | null | null | null | null | null | null | null | null | 2 | 1 | 2 | 1 | 1 | 15 | 120 | null | null | null | null | null | null | null | 10121 | 1 | null | null | null | (#keys=1) SUBSTR("RECEIPTNO",1,3)[VARCHAR2,12], COUNT(SUBSTR("RECEIPTNO",1,3))[22] | 1 | null |
null | 1004 | 08-OCT-19 | null | INDEX | FULL SCAN | null | FIDDLE_JIQQBFMHCVVQRJYBBOOG | IX_PURCHASE_1 | P@SEL$1 | null | INDEX | ANALYZED | null | 3 | 2 | 3 | 1 | 1 | 15 | 120 | null | null | null | null | null | null | null | 10121 | 1 | null | null | null | SUBSTR("RECEIPTNO",1,3)[VARCHAR2,12] | 1 | SEL$1 |