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

HP NonStop SQL/MX Query Guide—640323-001
vii
What’s New in This Manual
Manual Information
Abstract
This guide describes how to understand query execution plans and write optimal
queries for an HP NonStop™ SQL/MX database. It is intended for database
administrators and application developers who use NonStop SQL/MX to query an
SQL/MX database and who have a particular interest in issues related to query
performance.
Product Version
NonStop SQL/MX Releases 3.0
Supported Release Version Updates (RVUs)
This publication supports J06.11 and all subsequent J-series RVUs and H06.22 and all
subsequent H-series RVUs, until otherwise indicated by its replacement publications.
Document History
New and Changed Information
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-56.
•
Updated Optimization Tips on page 4-9.
Part Number Published
640323-001 February 2011
Part Number Product Version Published
640323-001
NonStop SQL/MX Release 3.0
February 2011