mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-18 21:44:02 +03:00
103 lines
2.2 KiB
Plaintext
103 lines
2.2 KiB
Plaintext
Operation: table access
|
|
Options: FULL
|
|
Object_type: TABLE
|
|
Other:
|
|
Object_owner: CALUSER01
|
|
Search_columns:
|
|
Projection: R_REGIONKEY^R_NAME
|
|
Object_name: REGION
|
|
Alias: REGION@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: N_NAME
|
|
Object_name: NATION
|
|
Alias: NATION@SEL$1
|
|
Extended_information: FP:N_REGIONKEY=R_REGIONKEY
|
|
Access_predicates:
|
|
Filter_predicates: N_REGIONKEY=R_REGIONKEY
|
|
Select_level: SEL$1
|
|
--------------------
|
|
Operation: nested loops
|
|
Options:
|
|
Object_type:
|
|
Other:
|
|
Object_owner:
|
|
Search_columns:
|
|
Projection: R_NAME^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: <N_REGIONKEY=R_REGIONKEY>
|
|
TOKEN: <N_REGIONKEY=R_REGIONKEY>
|
|
Operator: (
|
|
SimpleFilter
|
|
SimpleColumn tpch.NATION.N_REGIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_REGIONKEY/6//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//0
|
|
|
|
R_NAME: SimpleColumn tpch.REGION.R_NAME
|
|
s/t/c/T/A/RA: tpch/REGION/R_NAME/2/REGION/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.REGION.R_NAME
|
|
s/t/c/T/A/RA: tpch/REGION/R_NAME/2/REGION/0
|
|
|
|
SimpleColumn tpch.NATION.N_NAME
|
|
s/t/c/T/A/RA: tpch/NATION/N_NAME/5/NATION/0
|
|
|
|
>>Filters
|
|
SimpleFilter
|
|
SimpleColumn tpch.NATION.N_REGIONKEY
|
|
s/t/c/T/A/RA: tpch/NATION/N_REGIONKEY/6//0
|
|
Operator: = SimpleColumn tpch.REGION.R_REGIONKEY
|
|
s/t/c/T/A/RA: tpch/REGION/R_REGIONKEY/1/REGION/0
|
|
|
|
SessionID: 375
|
|
TxnID: 103
|
|
VerID: 103
|
|
--- Column Map ---
|
|
N_NAME : 0x8c41bc0
|
|
N_REGIONKEY : 0x8c42c18
|
|
R_NAME : 0x8c41b90
|
|
R_REGIONKEY : 0x8c15c90
|
|
|