Operation: table access Options: FULL Object_type: TABLE Other: Object_owner: CALUSER01 Search_columns: Projection: N2.N_NAME Object_name: NATION Alias: N2@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: N1.N_NAME Object_name: NATION Alias: N1@SEL$1 Extended_information: Access_predicates: Filter_predicates: Select_level: SEL$1 -------------------- Operation: buffer Options: SORT Object_type: Other: Object_owner: Search_columns: Projection: N2.N_NAME Object_name: Alias: Extended_information: Access_predicates: Filter_predicates: Select_level: -------------------- Operation: merge join Options: CARTESIAN 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: -------------------- N_NAME: SimpleColumn tpch.NATION.N_NAME s/t/c/T/A/RA: tpch/NATION/N_NAME/5/N2/0 N_NAME: SimpleColumn tpch.NATION.N_NAME s/t/c/T/A/RA: tpch/NATION/N_NAME/5/N1/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 empty filter tree SessionID: 322 TxnID: 71 VerID: 71 --- Column Map --- N_NAME : 0x8922c98 N_NAME : 0x894fb90