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

What’s New in This Manual
HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-003
xi
Changes to the H06.20/J06.09 manual:
Changes to the H06.20/J06.09 manual:

Updated the DISPLAY_EXPLAIN function with EXPLAIN statement on pages 1-8,
1-9, 1-11, 1-17, 1-18, 4-1, 4-2, 4-5, 4-6, 4-8, 5-2, 5-8, 8-17, 8-18, and 8-22.

Updated 7, SQL/MX Operators to add new tokens to the existing operators and to
provide an example for each operator.

Added the following operators:

BLOCKED_UNION Operator on page 7-5

EXPLAIN_CMD Operator on page 7-18

FirstN Operator on page 7-23

ORDERED_UNION Operator on page 7-56

SAMPLE_FILE_SCAN Operator on page 7-63

UNARY_UNION Operator on page 7-83
Changes to the H06.19/J06.08 Manual

Added Order of Evaluation of Predicates on page 1-14.

Added MultiUnion Support on page 1-16.

Added Using Constraint Based Query Pruning on page 1-16.

Updated the value of OPTS_PUSH_DOWN_DAM attribute on page 4-12.

Added MultiUnion Operator on page 7-47.
Changes to the H06.16/J06.05 Manual

References to Release Version Updates (RVUs) throughout this manual have been
updated to include references to J-series RVUs, where appropriate.

Updated the description of Sampling and UPDATE STATISTICS on page 3-6.

Added the token, max_results, under User-Defined Routine (UDR) on page 7-7.
Changes to the H06.05 Manual
Section New or Changed Information
Section 2, Accessing SQL/MX
Data
Example added that shows placing statements for
a forced shape into a separate module.
TP663851.fm Page xi Wednesday, January 30, 2013 5:37 PM