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
x
Changes to the H06.25/J06.14 manual:
Changes to the H06.25/J06.14 manual:

Added a new section, Improving Performance for the Left Join on page 1-19.

Updated the section, Forcing an Access Path on page 2-11.

Added a note to the section, Influencing the Optimizer to Use MDAM on page 2-16.

Added a note on the page 5-1.

Added a section Considerations for CONTROL QUERY SHAPE on page 5-18.

Updated the example in section ESP_EXCHANGE Operator on page 7-13.

Added the EXE_LONG_RUNNING Operator on page 7-16.

Updated the FILE_SCAN Operator on page 7-18.

Updated the ROOT Operator on page 7-61.

Updated the SEQUENCEGENERATOR Operator on page 7-66.

Added examples to the following operators:

ESP_ACCESS Operator on page 7-11.

NEXTVALUEFOR Operator on page 7-51.

SEQUENCEGENERATOR Operator on page 7-66.
Changes to the SQL/MX 3.1 manual:

Added ESP_ACCESS Operator on page 7-11

Added NEXTVALUEFOR Operator on page 7-51

Added SEQUENCEGENERATOR Operator on page 7-66
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-60.

Updated Optimization Tips on page 4-9.
TP663851.fm Page x Wednesday, January 30, 2013 5:37 PM