SQL/MX 2.x Query Guide (G06.24+, H06.03+)

HP NonStop SQL/MX Query Guide—523728-003
vii
What’s New in This Manual
Manual Information
HP NonStop SQL/MX Query Guide
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 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 2.0 and 2.1
Supported Release Version Updates (RVUs)
This publication supports G06.23 and all subsequent G-series RVUs until otherwise
indicated by its replacement publication.
Document History
New and Changed Information
Part Number Published
523728-003 June 2005
Part Number Product Version Published
429856-001 NonStop SQL/MX Release 1.5 November 2001
522677-001 NonStop SQL/MX Release 1.8 December 2002
523728-001 NonStop SQL/MX Release 2.0 April 2004
523728-002 NonStop SQL/MX Release 2.0 August 2004
523728-003 NonStop SQL/MX Releases 2.0 and 2.1 June 2005
Section New or Changed Information
Section 1, Compiling and
Executing a Query
Added information regarding use of a key column
in an expression that requires computation or a
function like UPSHIFT.
Section 2, Accessing SQL/MX
Data
Corrected alternate index access description.
Added information about new
INTERACTIVE_ACCESS system default setting.