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

What’s New in This Manual
HP NonStop SQL/MX Release 3.2 Query Guide—663851-002
xi
Changes to the H06.16/J06.05 Manual

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-46.
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.
Section 3, Keeping Statistics
Current
Added information about HIST_SCRATCH_VOL.
Section 4, Reviewing Query
Execution Plans
Clarified information about buffer size settings for
PARTITION_ACCESS operators.
Section 7, SQL/MX Operators Removed examples and corrected token
information.
TP663851.fm Page xi Thursday, August 2, 2012 4:47 PM