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 |