SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Reviewing Query Execution Plans
HP NonStop SQL/MX Query Guide—523728-003
4-17
Graphically Displaying Execution Plans
The Operator Properties dialog box, shown next, provides three tabs:
•
Node details
•
Cost details
•
Description
Notice the pushpin and ? icon in the upper left corner of the dialog box. You can pin
the dialog box open by selecting the pushpin so that you can select on another
operator without having to reopen the Properties dialog box. Select the ? icon for
context-sensitive help for the operator. The tabs in the Operator Properties dialog box
are described next.
Node Details
•
Statement Name is the name assigned to the prepared query; in this case, Q2.
•
Plan ID is a unique identifier generated during compile time.
•
Node Name describes the operator type; in this case, INDEX_SCAN.
VST504.vsd