SQL/MX 3.1 Query Guide (H06.23+, J06.12+)

HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
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.1
Supported Release Version Updates (RVUs)
This publication supports J06.12 and all subsequent J-series RVUs and H06.23 and all
subsequent H-series RVUs, until otherwise indicated by its replacement publications.
Document History
New and Changed Information
Changes to the SQL/MX 3.1 manual:

Added ESP_ACCESS Operator on page 7-11

Added NEXTVALUEFOR Operator on page 7-50

Added SEQUENCEGENERATOR Operator on page 7-65
Changes to the H06.22/J06.11 manual:

Updated a note in the Using Constraint Based Query Pruning on page 1-16.

Updated SQL/MX Objects in Table 3-1, Histogram Temporary Tables, on page 3-2.

Replaced schema version 1200 with 3000 in 3, Keeping Statistics Current, on
page 3-1.
Part Number Published
663851-001 October 2011
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
TP663851.fm Page ix Monday, October 17, 2011 11:48 AM