Manualshelf

SQL/MX 3.2.1 Query Guide (H06.26+, J06.15+)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series
81828384858687888990
Reviewing Query Execution Plans
HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-003
4-14
Using the Visual Query Planner
used. Operators appearing below the PARTITION_ACCESS operator are executing in
DAM.
Using the Visual Query Planner
Visual Query Planner is a Microsoft Windows NT GUI application that enables you to
extract and display query execution plans generated by the SQL/MX optimizer for DML
statements. Visual Query Planner uses the EXPLAIN function internally to extract the
information about the query plan.
You can save plans that you generate for further analysis. Saved plans can be sent to
anyone who can look at them without having to access the actual database. You can
also provide plans to the your support provider in case of problems. Visual Query
Planner also provides the ability to force the optimizer to present the plan that you
design. For further information, see Section 5, Forcing Execution Plans.
Visual Query Planner Requirements
In addition to NonStop SQL/MX, Visual Query Planner requires that you have data
sources defined for ODBC. You must have a PC or workstation with Windows NT 4.0
(or later) to use Visual Query Planner. For information about installing Visual Query
Planner, see the SQL/MX Release 3.2 Installation and upgrade Guide and SQL/MX
Release 3.2 Management Manual. For information about defining ODBC data sources
with the Microsoft ODBC Data Source Administrator, see the ODBC Driver for
Windows Manual.
Getting Help for Visual Query Planner
To access the Visual Query Planner online help facility, select Help > Visual Query
Planner Help. Access additional context-sensitive help by pressing F1 or through the
Properties dialog box. For more information, see Accessing Additional Information
About Operators on page 4-17.
Graphically Displaying Execution Plans
1. To start the Visual Query Planner, do one of the following:
Select Start > Programs > NonStop SQL-MX > Visual Query Planner.
Navigate to the C:\Program Files\Hewlett Packard\NonStop SQL-MX folder
and select and open Visual Query Planner.
After the program starts, you will notice that a default file name, VQP1,
appears on the title bar and that status messages appear along the bottom of
the window.
Note. To avoid unexpected results, turn off query caching at the start of your VQP session.
TP663851.fm Page 14 Wednesday, January 30, 2013 5:37 PM