mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-18 21:44:02 +03:00
162 lines
3.6 KiB
Plaintext
162 lines
3.6 KiB
Plaintext
Operation: table access
|
|
Options: FULL
|
|
Object_type: TABLE
|
|
Other:
|
|
Object_owner: CALUSER01
|
|
Search_columns:
|
|
Projection: N1.N_NATIONKEY^N1.N_NAME
|
|
Object_name: NATION
|
|
Alias: N1@SEL$1
|
|
Extended_information:
|
|
Access_predicates:
|
|
Filter_predicates:
|
|
Select_level: SEL$1
|
|
--------------------
|
|
Operation: table access
|
|
Options: FULL
|
|
Object_type: TABLE
|
|
Other:
|
|
Object_owner: CALUSER01
|
|
Search_columns:
|
|
Projection: N2.N_NATIONKEY^N2.N_NAME
|
|
Object_name: NATION
|
|
Alias: N2@SEL$1
|
|
Extended_information:
|
|
Access_predicates:
|
|
Filter_predicates:
|
|
Select_level: SEL$1
|
|
--------------------
|
|
Operation: sort
|
|
Options: JOIN
|
|
Object_type:
|
|
Other:
|
|
Object_owner:
|
|
Search_columns:
|
|
Projection: N1.N_NATIONKEY^N1.N_NAME
|
|
Object_name:
|
|
Alias:
|
|
Extended_information:
|
|
Access_predicates:
|
|
Filter_predicates:
|
|
Select_level:
|
|
--------------------
|
|
Operation: sort
|
|
Options: JOIN
|
|
Object_type:
|
|
Other:
|
|
Object_owner:
|
|
Search_columns:
|
|
Projection: N2.N_NATIONKEY^N2.N_NAME
|
|
Object_name:
|
|
Alias:
|
|
Extended_information: AFP:N1.N_NATIONKEY=N2.N_NATIONKEY(+)
|
|
Access_predicates: N1.N_NATIONKEY=N2.N_NATIONKEY(+)
|
|
Filter_predicates: N1.N_NATIONKEY=N2.N_NATIONKEY(+)
|
|
Select_level:
|
|
--------------------
|
|
Operation: merge join
|
|
Options: OUTER
|
|
Object_type:
|
|
Other:
|
|
Object_owner:
|
|
Search_columns:
|
|
Projection: N1.N_NAME^N2.N_NAME
|
|
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:
|
|
--------------------
|
|
TOKEN: <N1.N_NATIONKEY=N2.N_NATIONKEY(+)>
|
|
TOKEN: <N1.N_NATIONKEY=N2.N_NATIONKEY(+)>
|
|
TOKEN: <N1.N_NATIONKEY=N2.N_NATIONKEY(+)>
|
|
TOKEN: <N1.N_NATIONKEY=N2.N_NATIONKEY(+)>
|
|
Operator: (
|
|
SimpleFilter
|
|
SimpleColumn tpch.NATION.N_NATIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_NATIONKEY/4/N1/1
|
|
Operator: = SimpleColumn tpch.NATION.N_NATIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_NATIONKEY/4/N2/0
|
|
|
|
Operator: )
|
|
Operator: and
|
|
Operator: (
|
|
SimpleFilter
|
|
SimpleColumn tpch.NATION.N_NATIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_NATIONKEY/4/N1/1
|
|
Operator: = SimpleColumn tpch.NATION.N_NATIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_NATIONKEY/4/N2/0
|
|
|
|
Operator: )
|
|
N_NAME: SimpleColumn tpch.NATION.N_NAME
|
|
s/t/c/T/A/RA: tpch/NATION/N_NAME/5/N1/0
|
|
|
|
N_NAME: SimpleColumn tpch.NATION.N_NAME
|
|
s/t/c/T/A/RA: tpch/NATION/N_NAME/5/N2/0
|
|
|
|
N_NATIONKEY: SimpleColumn tpch.NATION.N_NATIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_NATIONKEY/4/N1/0
|
|
|
|
N_NATIONKEY: SimpleColumn tpch.NATION.N_NATIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_NATIONKEY/4/N2/0
|
|
|
|
>SELECT MAIN
|
|
>>Returned Columns
|
|
SimpleColumn tpch.NATION.N_NAME
|
|
s/t/c/T/A/RA: tpch/NATION/N_NAME/5/N1/0
|
|
|
|
SimpleColumn tpch.NATION.N_NAME
|
|
s/t/c/T/A/RA: tpch/NATION/N_NAME/5/N2/0
|
|
|
|
>>Filters
|
|
SimpleFilter
|
|
SimpleColumn tpch.NATION.N_NATIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_NATIONKEY/4/N1/1
|
|
Operator: = SimpleColumn tpch.NATION.N_NATIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_NATIONKEY/4/N2/0
|
|
|
|
SimpleFilter
|
|
SimpleColumn tpch.NATION.N_NATIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_NATIONKEY/4/N1/1
|
|
Operator: = SimpleColumn tpch.NATION.N_NATIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_NATIONKEY/4/N2/0
|
|
|
|
Operator: and
|
|
>>Group By Columns
|
|
SimpleColumn tpch.NATION.N_NATIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_NATIONKEY/4/N1/0
|
|
|
|
SimpleColumn tpch.NATION.N_NAME
|
|
s/t/c/T/A/RA: tpch/NATION/N_NAME/5/N1/0
|
|
|
|
SimpleColumn tpch.NATION.N_NATIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_NATIONKEY/4/N2/0
|
|
|
|
SimpleColumn tpch.NATION.N_NAME
|
|
s/t/c/T/A/RA: tpch/NATION/N_NAME/5/N2/0
|
|
|
|
SessionID: 343
|
|
TxnID: 81
|
|
VerID: 81
|
|
--- Column Map ---
|
|
N_NAME : 0x887bd08
|
|
N_NAME : 0x887bd68
|
|
N_NATIONKEY : 0x8846c98
|
|
N_NATIONKEY : 0x887bd38
|
|
|