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

Reviewing Query Execution Plans
HP NonStop SQL/MX Release 3.2 Query Guide—663851-002
4-18
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
TP663851.fm Page 18 Thursday, August 2, 2012 4:47 PM