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

What’s New in This Manual
HP NonStop SQL/MX Release 3.1 Query Guide—663851-001
x
Changes to the H06.20/J06.09 manual:

Updated Querying the Query Plan Caching Virtual Tables on page 6-13.

Added PROBE_CACHE Operator on page 7-59.

Updated Optimization Tips on page 4-9.
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-17

FirstN Operator on page 7-22

ORDERED_UNION Operator on page 7-54

SAMPLE_FILE_SCAN Operator on page 7-62

UNARY_UNION Operator on page 7-81
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-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.
TP663851.fm Page x Monday, October 17, 2011 11:48 AM