You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-30 19:23:07 +03:00
114 lines
2.5 KiB
Plaintext
114 lines
2.5 KiB
Plaintext
Operation: table access
|
|
Options: FULL
|
|
Object_type: TABLE
|
|
Other:
|
|
Object_owner: JLOWE
|
|
Search_columns:
|
|
Projection: N_REGIONKEY^N_NAME
|
|
Object_name: NATION
|
|
Alias: NATION@SEL$1
|
|
Extended_information:
|
|
Access_predicates:
|
|
Filter_predicates:
|
|
Select_level: SEL$5DA710D3
|
|
--------------------
|
|
Operation: table access
|
|
Options: FULL
|
|
Object_type: TABLE
|
|
Other:
|
|
Object_owner: JLOWE
|
|
Search_columns:
|
|
Projection: R_REGIONKEY
|
|
Object_name: REGION
|
|
Alias: REGION@SEL$2
|
|
Extended_information: FP:R_NAME='ASIA'
|
|
Access_predicates:
|
|
Filter_predicates: R_NAME='ASIA'
|
|
Select_level: SEL$5DA710D3
|
|
--------------------
|
|
Operation: hash join
|
|
Options: ANTI
|
|
Object_type:
|
|
Other:
|
|
Object_owner:
|
|
Search_columns:
|
|
Projection: N_NAME
|
|
Object_name:
|
|
Alias:
|
|
Extended_information: AP:N_REGIONKEY=R_REGIONKEY
|
|
Access_predicates: N_REGIONKEY=R_REGIONKEY
|
|
Filter_predicates:
|
|
Select_level: SEL$5DA710D3
|
|
--------------------
|
|
Operation: select statement
|
|
Options:
|
|
Object_type:
|
|
Other:
|
|
Object_owner:
|
|
Search_columns:
|
|
Projection:
|
|
Object_name:
|
|
Alias:
|
|
Extended_information:
|
|
Access_predicates:
|
|
Filter_predicates:
|
|
Select_level:
|
|
--------------------
|
|
TOKEN: <R_NAME='ASIA'>
|
|
TOKEN: <R_NAME='ASIA'>
|
|
TOKEN: <N_REGIONKEY=R_REGIONKEY>
|
|
TOKEN: <N_REGIONKEY=R_REGIONKEY>
|
|
Operator: (
|
|
SimpleFilter
|
|
SimpleColumn tpch.REGION.R_NAME
|
|
s/t/c/T/A/RA: tpch/REGION/R_NAME/2//0
|
|
Operator: = ConstantColumn: ASIA(l)
|
|
Operator: )
|
|
Operator: and
|
|
Operator: (
|
|
SimpleFilter
|
|
SimpleColumn tpch.NATION.N_REGIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_REGIONKEY/6/NATION/0
|
|
Operator: = SimpleColumn tpch.REGION.R_REGIONKEY
|
|
s/t/c/T/A/RA: tpch/REGION/R_REGIONKEY/1/REGION/0
|
|
|
|
Operator: )
|
|
N_NAME: SimpleColumn tpch.NATION.N_NAME
|
|
s/t/c/T/A/RA: tpch/NATION/N_NAME/5/NATION/0
|
|
|
|
N_REGIONKEY: SimpleColumn tpch.NATION.N_REGIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_REGIONKEY/6/NATION/0
|
|
|
|
R_NAME: SimpleColumn tpch.REGION.R_NAME
|
|
s/t/c/T/A/RA: tpch/REGION/R_NAME/2//0
|
|
|
|
R_REGIONKEY: SimpleColumn tpch.REGION.R_REGIONKEY
|
|
s/t/c/T/A/RA: tpch/REGION/R_REGIONKEY/1/REGION/0
|
|
|
|
>SELECT MAIN
|
|
>>Returned Columns
|
|
SimpleColumn tpch.NATION.N_NAME
|
|
s/t/c/T/A/RA: tpch/NATION/N_NAME/5/NATION/0
|
|
|
|
>>Filters
|
|
SimpleFilter
|
|
SimpleColumn tpch.REGION.R_NAME
|
|
s/t/c/T/A/RA: tpch/REGION/R_NAME/2//0
|
|
Operator: = ConstantColumn: ASIA(l)
|
|
SimpleFilter
|
|
SimpleColumn tpch.NATION.N_REGIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_REGIONKEY/6/NATION/0
|
|
Operator: = SimpleColumn tpch.REGION.R_REGIONKEY
|
|
s/t/c/T/A/RA: tpch/REGION/R_REGIONKEY/1/REGION/0
|
|
|
|
Operator: and
|
|
SessionID: 267
|
|
TxnID: 52
|
|
VerID: 52
|
|
--- Column Map ---
|
|
N_NAME : 0x986daa8
|
|
N_REGIONKEY : 0x9840c00
|
|
R_NAME : 0x986db38
|
|
R_REGIONKEY : 0x986dad8
|
|
|