TEMP (Temporary table) node

This node represents the storage of data in a temporary table.

Node name: TEMP

Represents: The action of storing data in a temporary table, to be read back out by another node (possibly multiple times). The table is removed after the SQL or XQuery statement is processed, if not before.

Note: XQuery is supported by Visual Explain only.

This node is required to evaluate subqueries or to store intermediate results. In some situations (such as when the statement can be updated), it might be mandatory.


Feedback