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

HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-003
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.1
Supported Release Version Updates (RVUs)
This publication supports J06.15 and all subsequent J-series RVUs and H06.26 and all
subsequent H-series RVUs, until otherwise indicated by its replacement publications.
Document History
New and Changed Information
Changes to the H06.26/J06.15 manual:

Updated the section Improving Performance for the Left Join on page 1-19.

Updated the follwoing operators:

ESP_ACCESS Operator on page 7-11.

NEXTVALUEFOR Operator on page 7-51.

SEQUENCEGENERATOR Operator on page 7-66.

Added a new section Shapes and Sequence Generators on page 5-10.
Part Number Published
663851-003 February 2013
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
663851-003
NonStop SQL/MX Release 3.2.1
February 2013
TP663851.fm Page ix Wednesday, January 30, 2013 5:37 PM