| AND-EQUAL |
ANDEQ |
Operator for accepting multiple sets of rowids,
returning the intersection of the sets, and eliminating duplicates |
| BITMAP |
BITMAP |
Operator to use bitmaps for access; there are
different options available for the optimizer to choose from |
| BUFFER |
BUFFER |
Buffer operator |
| CONCATENATION |
CONCAT |
Operator for accepting multiple sets of rows;
it returns the union-all of the sets |
| CONNECT BY |
CONNBY |
Operator to retrieve rows in hierarchical order
for a query containing a CONNECT BY clause |
| COUNT |
COUNT |
Operator for counting the number of rows selected
from a table |
| FAST |
FAST |
Fast extract to an accelerated database unload |
| FILTER |
FILTER |
Operator to accept a set of rows, eliminate
some of them, and return the rest |
| FIRST_ROW |
FROW |
First row access only |
| FOR_UPDATE |
FORUPD |
Operator to retrieve and lock the rows selected
by a query containing a FOR UPDATE clause |
| HASH |
HASH |
Operator to hash a set of rows into groups |
| HASH_JOIN |
HJOIN |
Hash join operator |
| INDEX_SCAN |
INDX |
Index scan operator |
| INLIST_ITERATOR |
INLSTITR |
Operator to process the next operation in the
plan for each value in the IN-list predicate |
| INTERSECTION |
INTRSCT |
Operator to accept two sets of rows and return
the intersection of the sets eliminating duplicates |
| MERGE_JOIN |
MJOIN |
Merge join operator |
| MINUS |
MINUS |
Operator to accept two sets of rows and return
rows appearing in the first set but not in the second eliminating
duplicate |
| NESTED_LOOPS |
NLJOIN |
Nested loop join operator |
| PARTITION |
PART |
Partition access operator; works for either
table or index partitions |
| PX ITERATOR |
PXI |
Operator to implement the division of an object
into block or chunk ranges in a set of parallel slave partitions |
| PX_BLOCK |
PXB |
Operator to implement the division of an object
into block ranges among a set of parallel slave partitions |
| PX_COORDINATOR |
PXC |
Operator to implement the Query Coordinator
which controls, schedules, and executes the parallel plan |
| PX_RECEIVE |
PXR |
Operator that shows the consumer/receiver slave
node reading repartitioned data from a send/producer (QC or slave)
executing on a PX SEND node |
| PX_SEND |
PXS |
Operator that shows the boundary between two
slave sets and how data is repartitioned on the send/producer side |
| REMOTE |
REMOTE |
Operator to retrieve data from a remote database |
| SELECT_STATEMENT |
SELSTMT |
Select statement operator |
| SEQUENCE |
SEQ |
Operator to access the values of a sequence |
| SORT |
SORT |
SORT statement operator |
| TABLE_ACCESS |
TBSCAN |
Table scan operator |
| TRANSPOSE |
TRAN |
Operator to evaluate a PIVOT operation by transposing
the results of GROUP BY to produce the final pivoted data |
| UNION |
UNION |
Operator to accept two sets of rows and return
the union of the sets eliminating duplicates |
| UNION-ALL |
UNIONA |
Operator to accept multiple sets of rows returning
the union-all of the sets |
| UNPIVOT |
UNPIVOT |
Operator to convert column-based data into separate
rows |
| WINDOW |
WINDOW |
Window operator |
| PARTITION RANGE |
PRANGE |
Operator to access partition range |
| PIVOT |
PIVOT |
Operator to take data in separate rows, aggregate
and convert the data into columns |
| INSERT STATEMENT |
INSSTMT |
INSERT statement operator |
| UPDATE STATEMENT |
UPDSTMT |
UPDATE statement operator |
| LOAD TABLE CONVENTIONAL |
LDTBL |
Load table operator |
| UPDATE |
UPDATE |
Update operator |
| CONNECT BY PUMP |
CONNPUMP |
Operator to participate in a hierarchical self-join |
| DELETE STATEMENT |
DELSTMT |
DELETE statement operator |
| DELETE |
DELETE |
DELETE operator |
| TABLE ACCESS FULL |
TBFULL |
Operator to retrieve all rows from a table |
| TABLE ACCESS SAMPLE |
TBSAMPL |
Operator to retrieve sampled rows from a table |
| TABLE ACCESS CLUSTER |
TBCLUSTR |
Operator to retrieve rows from a table based
on a value of an indexed cluster key |
| TABLE ACCESS HASH |
TBHASH |
Operator to retrieve rows from a table based
on a hash cluster key value |
| TABLE ACCESS BY ROWID RANGE |
TBRIDRNG |
Operator to retrieve rows from a table based
on a rowid range |
| TABLE ACCESS SAMPLE BY ROWID RANGE |
TBSRIDRNG |
Operator to retrieve sampled rows from a table
based on a rowid range |
| TABLE ACCESS BY USER ROWID |
TBURID |
Operator to retrieve table rows by using user-supplied
rowids |
| TABLE ACCESS BY INDEX ROWID |
TBIRID |
Operator to retrieve table rows where table
is nonpartitioned and rows are located using indexes |
| TABLE ACCESS BY GLOBAL INDEX ROWID |
TBGIRID |
Operator to retrieve table rows, when the table
is partitioned and rows are located using only global indexes |
| TABLE ACCESS BY LOCAL INDEX ROWID |
TBLIRID |
Operator to retrieve table rows, when the table
was accessed using rowids from a local index |
| INDEX UNIQUE |
IXUNIQ |
Operator to retrieve table rows by using the
unique index |
| INDEX RANGE |
IXRANGE |
Operator to retrieve table rows by using index
in Range Scan mode (Ascending) |
| INDEX RANGE DESCENDING |
IXRANGED |
Operator to retrieve table rows by using index
Range Scan mode (Descending) |
| INDEX FULL |
IXFULL |
Operator to retrieve table rows by a full index
scan |
| INDEX FULL DESCENDING |
IXFULLD |
Operator to retrieve table rows by performing
a full index scan in descending order |
| INDEX FAST FULL SCAN |
IXFASTFS |
Operator to retrieve table rows by a fast full
scan of the index |
| INDEX SKIP SCAN |
IXSKIPS |
Operator to perform an index scan using concatenated
index |
| XPATH EVALUATION |
XPATHEVAL |
Operator to perform XPATH evaluation in a query |
| SORT UNIQUE |
SORTUNIQ |
Sort operator to eliminate duplicate rows |
| SORT GROUP BY |
SORTGRP |
Sort operator to support group |
| SORT JOIN |
SORTJOIN |
Sort operator for parent join operation |
| SORT ORDER BY |
SORTORDBY |
Sort operator for ORDER BY |
| SORT GROUP BY PIVOT |
SORTGRPP |
Sort operator for a group by Pivot operation |
| SORT AGGREGATE |
SORTAGG |
Sort operator for a group operation |
| FAST DUAL |
FASTDUAL |
Operator involving a dual system table |
| MERGE STATEMENT |
MERGSTMT |
Merge statement operator |
| MERGE |
MERGE |
Merge operator |
| COLLECTION ITERATOR |
COLLITR |
Operator to use a collection iterator (iterating
through a table function) |
| BITMAP CONVERSION |
BMAPCONV |
Operator to perform bitmap conversion to rowids
or bitmap conversion from rowids |
| BITMAP INDEX |
BMAPINDX |
Operator to perform a bitmap index scan, including
a full, a range or a single value scan |
| BITMAP AND |
BMAPAND |
Operator to perform AND operation on the bitmaps |
| LOAD AS SELECT |
LOADASSEL |
LOAD AS SELECT operator |
| TEMP TABLE TRANSFORMATION |
TMPTABTRANS |
Temporary table transformation operator |