Nodes specific to Oracle databases

When you use Visual Explain for SQL statements that run on Oracle databases, Visual Explain uses these nodes in access plan graphs.
The values in the Operator short name field are displayed in the Visual Explain diagram. If you hover over the node, the long name will also be displayed.
Table 1. Oracle data server nodes
Operator long name Operator short name Description
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

Feedback