1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-07-29 08:21:15 +03:00
Files
mariadb-columnstore-engine/dbcon/doc/oraclexplan/tableaccessbyindexrowid01.log
2016-01-06 14:08:59 -06:00

44 lines
866 B
Plaintext

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: <O_ORDERKEY<500>