Nodes for DB2 for Linux, UNIX, and Windows
Access plan graphs use the following nodes for DB2® for Linux®, UNIX®, and Windows®.
CMPEXP node
This node is for debug mode only.
DELETE node
This node represents the deletion of rows from a table.
EISCAN node
This node scans a user defined index to produce a reduced stream of rows.
FETCH
This node represents the fetching of columns from a table.
FILTER node
This node represents how data is filtered.
GENROW node
This node is used by the optimizer to generate rows of data.
GRPBY node
This node represents the grouping of rows.
HSJOIN node
This node represents hash joins for which the qualified rows from tables are hashed.
INSERT node
This node represents the insertion of rows into a table.
IXAND node
This node represents the ANDing of the results of multiple index scans.
IXSCAN
This node represents the scanning of an index.
MSJOIN node
This node represents a merge join.
NLJOIN node
This node represents a nested loop join.
PIPE node
This node is for debug mode only.
QUERY node
This node represents the return of data from a query.
RIDSCN node
This node represents the scan of a list of row identifiers (RIDs).
RPD node
This node retrieves data from a remote data source.
SHIP node
This node retrieves data from a remote data source.
SORT node
This node represents the sorting of rows in a table.
TBSCAN node
This node represents table scans.
TEMP node
This node represents the storage of data in a temporary table.
TQ node
This node represents a table queue.
UNION node
This node represents the concatenation of steams of rows from multiple tables.
UNIQUE node
This node represents rows with duplicate values.
UPDATE node
This node represents the updating of data in the rows of a table.
XANDOR node
This node allows ANDed predicates to be applied to multiple indexes to reduce underlying table accesses to a minimum.
XISCAN node
This operation is performed for a single query predicate.
XSCAN node
This node is used to navigate XML fragments to evaluate XPath expressions and to extract document fragments if needed.
Feedback