Operation: index Options: RANGE SCAN Object_type: INDEX (UNIQUE) Other: Object_owner: CALUSER01 Search_columns: 1 Projection: ORDERS.ROWID^O_ORDERKEY Object_name: Alias: ORDERS@SEL$1 Extended_information: AP:O_ORDERKEY<500 Access_predicates: O_ORDERKEY<500 Filter_predicates: Select_level: SEL$1 -------------------- Operation: table access Options: BY INDEX ROWID Object_type: TABLE Other: Object_owner: CALUSER01 Search_columns: Projection: O_ORDERKEY^O_CUSTKEY Object_name: ORDERS Alias: ORDERS@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: -------------------- TOKEN: