Execution plan image:
Partition operation.
The INVALID PARTITION operation returns if partition set being accessed is empty.
Execution plan image:
Partition operation.
Accesses multiple partitions. Iterates over the operation below it, for each partition in the range given by the PARTITION_START and PARTITION_STOP columns.
Execution Plan image:
Row operation.
LOAD AS SELECT bypasses the buffer cache when performing a direct path load based on a SELECT statement.
An Execution plan will denote the presence of a direct load operation with the LOAD AS SELECT operation:
Rows |
Execution Plan |
0 |
SELECT STATEMENT GOAL: CHOOSE |
0 |
LOAD AS SELECT |
0 |
TABLE ACCESS (FULL) OF 'CUSTOMERS' |
Operation: MAT_VIEW ACCESS
Option: BY INDEX ROWID
The MAT_VIEW ACCESS BY INDEX ROWID operation retrieves data from a materialized view based on index ROWIDs.
Option: BY ROWID RANGE
The MAT_VIEW ACCESS BY ROWID RANGE operation retrieves data from a materialized view based on a provided range of ROWIDs.
Option: BY USER ROWID
The MAT_VIEW ACCESS BY USER ROWID operation retrieves data from a materialized view based on a specific ROWID.
Option: FULL
The MAT_VIEW ACCESS FULL operation retrieves data based on a full table scan of a materialized view.
Option: SAMPLE
The MAT_VIEW ACCESS SAMPLE operation retrieves data based on a full table sample scan of a materialized view.
Option: SAMPLE BY ROWID RANGE
The MAT_VIEW ACCESS SAMPLE BY ROWID RANGE operation retrieves data based on a full table sample scan for a provided range of ROWIDs of a materialized view.
© ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center