SQL/MX 3.2.1 Query Guide (H06.26+, J06.15+)

Hewlett-Packard Company—663851-003
i
HP NonStop SQL/MX Release
3.2.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 H06.25/J06.14 manual: ix
Changes to the SQL/MX 3.1 manual: x
Changes to the H06.22/J06.11 manual: x
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 xi
Changes to the H06.05 Manual xi
About This Manual xiii
Audience xiii
Organization xiii
Related Documentation xiv
Notation Conventions xvi
Hypertext Links
xvi
General Syntax Notation xvi
Change Bar Notation
xviii
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-21
How the Executor Processes the Plan
1-21
TP663851.fm Page i Wednesday, January 30, 2013 5:37 PM