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
x
Changes to the SQL/MX 3.1 manual:

Updated the FILE_SCAN Operator on page 7-17.

Updated the ROOT Operator on page 7-59.

Updated the SEQUENCEGENERATOR Operator on page 7-65.
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.

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.
TP663851.fm Page x Thursday, August 2, 2012 4:47 PM