SQL/MX 3.2 Query Guide (H06.25+, J06.14+)

SQL/MX Operators

HP NonStop SQL/MX Release 3.2 Query Guide—663851-002

7-15

EXE_LONG_RUNNING Operator

An EXE_LONG_RUNNING operator describes a portion of a DELETE execution plan

that can involve a large set of rows.

An ESP_EXCHANGE operator is used to coordinate and execute the delete operation

in each partition. Each partition-specific DELETE statement is sub-divided into multiple

DELETE statements, each of which is executed in an independent transaction.

This operator has no child nodes. The description field for this operator contains the

following:

Token Followed by ... Data Type

fragment_id A sequential number assigned to the

fragment. 0 is always the master

executor, and 1 is reserved for the

EXPLAIN plan. Numbers 2 to n will be

ESP or DAM fragments.

integer

parent_frag The fragment_id for the parent of the

current fragment. The value is (none)

for the master executor.

integer

fragment_type Master, ESP, or DP2. text

multi_commit Indicates whether the multi_commit is

ON or OFF.

text

multi_commit_size The number of records that are deleted

by each child transaction in each ESP.

integer

TP663851.fm Page 15 Thursday, August 2, 2012 4:47 PM