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

Hewlett-Packard Company—663851-001
i
HP NonStop SQL/MX Release
3.1 Query Guide
Index Examples Figures Tables
Legal Notices
What’s New in This Manual ix
Manual Information
ix
New and Changed Information
ix
Changes to the SQL/MX 3.1 manual: ix
Changes to the H06.22/J06.11 manual: ix
Changes to the H06.20/J06.09 manual: x
Changes to the H06.19/J06.08 Manual x
Changes to the H06.16/J06.05 Manual x
Changes to the H06.05 Manual xi
About This Manual xiii
Audience xiii
Organization xiii
Related Documentation xiv
Notation Conventions xvii
Hypertext Links xvii
General Syntax Notation
xvii
Change Bar Notation xix
1. Compiling and Executing a Query
Overview 1-1
How the Compiler Works
1-2
Compilation Steps 1-2
Parsing, Binding, and Normalizing
1-3
Query Plan Caching
1-5
Improving Query Performance 1-6
Factors That Can Affect Compile Time 1-19
How the Executor Processes the Plan
1-19
2. Accessing SQL/MX Data
Access Methods 2-1
TP663851.fm Page i Monday, October 17, 2011 11:48 AM