Node | Functionality |
AGGREGATION | Shows plans for aggregate functions that are not part of a GROUP BY clause. |
CROSS JOIN | Merges two streams of incoming rows and produces one stream of rows that is the Cartesian product of the two streams. |
Pre Data Ship Plan | Represents the query execution analysis prior to the shipment of one or multiple nodes to the data ship target. After a data ship is executed, each of the Pre Data Ship Plan nodes state: Execution Status: NOT EXECUTED. This operation was determined unnecessary or was cancelled before any rows were retrieved. The Pre Data Ship Plan nodes are not executed because the query is reworked to execute the operation on the data ship target. |
DISTINCT | Removes all incoming duplicate rows. |
FETCH | Produces the rows resulting from execution of a query on a data source. The information that can be displayed includes: • Estimated rows returned (or “Unknown”) • Data source path, type, and driver name • Data ship target, if data ship is being used • Data ship notes, if any • SQL of the fetch • SAP BW OLAP View runtime notes with estimated rows returned The FETCH node and the SQL submitted to the data ship target reveals how a query that uses data shipment is rewritten to select data that was shipped into a local temp table to make it available for a collocated operation compared to the operation that was evaluated in the Pre Data Ship Plan. |
FILTER | Passes through only the incoming rows that satisfy the filter criterion. |
FULL OUTER JOIN | Merges two streams of incoming rows and produces one stream containing the SQL FULL OUTER JOIN of the two streams. Refer to SQL reference materials for a description of FULL OUTER JOIN. |
FUNCTION | Shows how a function is executed. |
GROUP BY | Reorders the incoming rows so that they are grouped by some criterion. For example, if the rows are grouped by a name, all rows with the same name are combined into a single row. |
IN SUBQUERY | Lists a node for an unpushed IN subqueries. |
JOIN | Merges two streams of incoming rows and produces one stream containing rows that satisfy a criterion that applies to both streams. The information displayed includes: • Estimated rows returned (or “Unknown”) • Criterion applied • Algorithm used • Algorithm notes • Estimated left and right cardinality |
ORDER BY | Reorders the incoming rows to satisfy a sorting criterion. |
PROCEDURE | Produces rows resulting in the execution of a query or stored procedure call on a data source. The information displayed includes: • Estimated rows returned (or “Unknown”) • Location of the SQL statement • Reason for not pushing if that is the case |
RIGHT OUTER JOIN | A right outer join performed as part of a stored procedure. Merges two streams of incoming rows and produces one stream containing the SQL right-outer-join of the two streams. Refer to SQL reference materials for a description of RIGHT OUTER JOIN. |
SELECT | Applies functions on the column values of the rows. This node produces the same number of rows that it reads. The information displayed includes: • Estimated rows returned (or “Unknown”) • Projection of the SELECT statement • Data ship notes, if any |
UNION | Combines two streams of incoming rows and produces a single stream. The cardinality of produced rows equals the sum of the cardinality of the incoming streams. The order in which the node produces rows is undefined. |
CROSS PROCEDURE JOIN | A cross-join performed as part of a stored procedure. |
FULL OUTER PROCEDURE JOIN | A full outer join performed as part of a stored procedure. |
FETCH WITH | Same as FETCH, but containing a specified condition. |
UPDATE | Updates a data source, typically a table. |
INSERT | Inserts data into a data source, typically a table. |
DELETE | Deletes data from data source, typically a table. |
MERGE | Merges data into a data source, typically a table. Merge inserts a row if it is not present, and updates a row if it already exists. |
WITH SUBQUERIES | Subqueries that are part of WITH clauses. |
INTERSECT | |
EXCEPT |