1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-07-29 08:21:15 +03:00
Files
mariadb-columnstore-engine/dbcon/doc/oraclexplan/hashgroupby01.log
2016-01-06 14:08:59 -06:00

75 lines
1.4 KiB
Plaintext

Operation: table access
Options: FULL
Object_type: TABLE
Other:
Object_owner: JLOWE
Search_columns:
Projection: O_CUSTKEY
Object_name: ORDERS
Alias: ORDERS@SEL$1
Extended_information:
Access_predicates:
Filter_predicates:
Select_level: SEL$1
--------------------
Operation: hash
Options: GROUP BY
Object_type:
Other:
Object_owner:
Search_columns:
Projection: O_CUSTKEY^COUNT(ALL)
Object_name:
Alias:
Extended_information:
Access_predicates:
Filter_predicates:
Select_level: SEL$1
--------------------
Operation: select statement
Options:
Object_type:
Other:
Object_owner:
Search_columns:
Projection:
Object_name:
Alias:
Extended_information:
Access_predicates:
Filter_predicates:
Select_level:
--------------------
O_CUSTKEY: SimpleColumn tpch.ORDERS.O_CUSTKEY
s/t/c/T/A/RA: tpch/ORDERS/O_CUSTKEY/17/ORDERS/0
>SELECT MAIN
>>Returned Columns
SimpleColumn tpch.ORDERS.O_CUSTKEY
s/t/c/T/A/RA: tpch/ORDERS/O_CUSTKEY/17/ORDERS/0
ArithmeticColumn: AggregateColumn count(ALL)
ArithmeticColumn: SimpleColumn ALL
s/t/c/T/A/RA: //ALL/0//0
>>Filters
empty filter tree
>>Group By Columns
SimpleColumn tpch.ORDERS.O_CUSTKEY
s/t/c/T/A/RA: tpch/ORDERS/O_CUSTKEY/17/ORDERS/0
ArithmeticColumn: AggregateColumn count(ALL)
ArithmeticColumn: SimpleColumn ALL
s/t/c/T/A/RA: //ALL/0//0
SessionID: 255
TxnID: 44
VerID: 44
--- Column Map ---
O_CUSTKEY : 0x825cc00