Nodes for DB2® for Linux®, UNIX®, and Windows®
The following nodes can appear in representations of access plans for the SQL statements that run on DB2 for Linux, UNIX, and Windows.
CMPEXP node
This node is for debug mode only.
DELETE (Delete) node
This node represents the deletion of rows from a table.
EISCAN (User-defined index scan) node
This node scans a user defined index to produce a reduced stream of rows.
FETCH (Fetch) node
This node represents the fetching of columns from a table.
FILTER (Filter data) node
This node represents how data is filtered.
GENROW (Generate table rows) node
This node is used by the optimizer to generate rows of data.
GRPBY (Group by) node
This node represents the grouping of rows.
HSJOIN (Hash join) node
This node represents hash joins for which the qualified rows from tables are hashed.
INSERT (Insert) node
This node represents the insertion of rows into a table.
IXAND (Index sets intersection) node
This node represents the ANDing of the results of multiple index scans.
IXSCAN (Index scan) node
This node represents the scanning of an index.
MSJOIN (Merge scan join) node
This node represents a merge join.
NLJOIN (Nested loop join) 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 (Row identifier (RID) scan) 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 (Remote data fetch) node
This node retrieves data from a remote data source.
SORT (Sort ) node
This node represents the sorting of rows in a table.
TBSCAN (Table scan) node
This node represents table scans.
TEMP (Temporary table) node
This node represents the storage of data in a temporary table.
TQ (Table queue) node
This node represents a table queue.
UNION (Union) node
This node represents the concatenation of steams of rows from multiple tables.
UNIQUE (Duplicate elimination) node
This node represents rows with duplicate values.
UPDATE (Update) node
This node represents the updating of data in the rows of a table.
XANDOR (XML index anding) node
This node allows ANDed predicates to be applied to multiple indexes to reduce underlying table accesses to a minimum.
XISCAN (Index scan over XML data) node
This operation is performed for a single query predicate.
XSCAN (XML document scan) node
This node is used to navigate XML fragments to evaluate XPath expressions and to extract document fragments if needed.
Feedback