SQL/MX 3.x Query Guide (H06.22+, J06.11+)

What’s New in This Manual
HP NonStop SQL/MX Query Guide—640323-001
viii
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-4
°
EXPLAIN_CMD Operator on page 7-15
°
FirstN Operator on page 7-20
°
ORDERED_UNION Operator on page 7-52
°
SAMPLE_FILE_SCAN Operator on page 7-59
°
UNARY_UNION Operator on page 7-77
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-44.
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-6.
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.