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: 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/NATION/0 >SELECT MAIN >>Returned Columns SimpleColumn tpch.NATION.N_NAME s/t/c/T/A/RA: tpch/NATION/N_NAME/5/NATION/0 >>Filters empty filter tree SessionID: 411 TxnID: 125 VerID: 125 --- Column Map --- N_NAME : 0x9735c90 Operation: table access Options: FULL Object_type: TABLE Other: Object_owner: CALUSER01 Search_columns: Projection: L_QUANTITY^L_EXTENDEDPRICE Object_name: LINEITEM Alias: LINEITEM@SEL$1 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: -------------------- L_EXTENDEDPRICE: SimpleColumn tpch.LINEITEM.L_EXTENDEDPRICE s/t/c/T/A/RA: tpch/LINEITEM/L_EXTENDEDPRICE/30/LINEITEM/0 L_QUANTITY: SimpleColumn tpch.LINEITEM.L_QUANTITY s/t/c/T/A/RA: tpch/LINEITEM/L_QUANTITY/29/LINEITEM/0 >SELECT MAIN >>Returned Columns SimpleColumn tpch.LINEITEM.L_QUANTITY s/t/c/T/A/RA: tpch/LINEITEM/L_QUANTITY/29/LINEITEM/0 SimpleColumn tpch.LINEITEM.L_EXTENDEDPRICE s/t/c/T/A/RA: tpch/LINEITEM/L_EXTENDEDPRICE/30/LINEITEM/0 >>Filters empty filter tree SessionID: 411 TxnID: 126 VerID: 126 --- Column Map --- L_EXTENDEDPRICE : 0x9769cf8 L_QUANTITY : 0x9735c90