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

HP NonStop SQL/MX Release 3.2 Query Guide—663851-002
ix
What’s New in This Manual
Manual Information
Abstract
This guide describes how to understand query execution plans and write optimal
queries for an HP NonStop™ SQL/MX database. It is intended for database
administrators and application developers who use NonStop SQL/MX to query an
SQL/MX database and who have a particular interest in issues related to query
performance.
Product Version
NonStop SQL/MX Releases 3.2
Supported Release Version Updates (RVUs)
This publication supports J06.14 and all subsequent J-series RVUs and H06.25 and all
subsequent H-series RVUs, until otherwise indicated by its replacement publications.
Document History
New and Changed Information
Changes to the H06.25/J06.14 manual:

Added a new section, Improving Performance for the Left Join on page 1-19.

Updated the section, Forcing an Access Path on page 2-11.

Added a note to the section, Influencing the Optimizer to Use MDAM on page 2-16.

Added a note on the page 5-1.

Added a section Considerations for CONTROL QUERY SHAPE on page 5-17.

Updated the example in section ESP_EXCHANGE Operator on page 7-12.

Added the EXE_LONG_RUNNING Operator on page 7-15.
Part Number Published
663851-002 August 2012
Part Number Product Version Published
640323-001
NonStop SQL/MX Release 3.0
February 2011
663851-001
NonStop SQL/MX Release 3.1
October 2011
663851-002
NonStop SQL/MX Release 3.2
August 2012
TP663851.fm Page ix Thursday, August 2, 2012 4:47 PM