SQL/MX 2.x Query Guide (H06.04+, J06.03+)

Reviewing Query Execution Plans
HP NonStop SQL/MX Query Guide—540437-005
4-15
Graphically Displaying Execution Plans
2. Select Explain > Connect to ODBC to connect to your ODBC data source.
For more information about connecting to MXCS, see the SQL/MX Connectivity
Services Manual.
After you are connected to your data source, notice that the status message along
the bottom of the window displays the data source name. Also notice that the
Connect to ODBC icon on the toolbar is dimmed, indicating that the connection
has been made.
3. In the top pane of the Visual Query Planner window, enter your query.
You must enter (or copy) the query rather than trying to execute a prepared query.
Visual Query Planner internally prepares the query and assigns it a statement
name.
4. Select Explain > Get Explain Plan to direct the EXPLAIN function to prepare and
display the query.
The operator tree for the query execution plan appears in the lower left pane of the
window (operator tree pane). Summary details for the operators appear in the right
lower pane of the window (summary detail pane). You can sort the summary detail
by clicking a column name to sort on that column. Figure 4-2 on page 4-16 shows
a query in the top pane and the subsequent query execution plan in the left lower
pane of the window.
Note. MXCS must be running on the server before you can connect Visual Query Planner
to MXCS.