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

HP NonStop SQL/MX Query Guide—640323-001
3
6. Query Plan Caching
What Happens if No Plan Is Returned? 5-10
Migrating Forced Shapes From NonStop SQL/MP 5-10
Forcing Group By Operations to the Data Access Manager 5-10
Forcing Parallel Plans 5-13
6. Query Plan Caching
Overview 6-1
Types of Cacheable Queries 6-2
Examples of Cacheable Expressions 6-3
Examples of Queries That Are Not Cacheable 6-4
Choosing an Appropriate Size for the Query Cache 6-6
Query Plan Caching Statistics 6-6
SYSTEM_DEFAULTS Table Settings for Query Plan Caching Attributes 6-7
QUERYCACHE Function 6-9
QUERYCACHEENTRIES Function 6-11
Querying the Query Plan Caching Virtual Tables 6-13
Reviewing the Query Plan Caching Statistics With the DISPLAY_QC and
DISPLAY_QC_ENTRIES Commands 6-15
7. SQL/MX Operators
Operators 7-4
BLOCKED_UNION Operator 7-4
CALL Operator 7-5
CURSOR_DELETE Operator 7-7
CURSOR_UPDATE Operator 7-9
ESP_EXCHANGE Operator 7-10
EXPLAIN Operator 7-13
EXPR Operator
7-14
EXPLAIN_CMD Operator
7-15
FILE_SCAN Operator 7-15
FILE_SCAN_UNIQUE Operator 7-17
FirstN Operator 7-20
HASH_GROUPBY Operator 7-20
HASH_PARTIAL_GROUPBY_LEAF Operator 7-22
HASH_PARTIAL_GROUPBY_ROOT Operator 7-23
HYBRID_HASH_ANTI_SEMI_JOIN Operator 7-24
HYBRID_HASH_JOIN Operator 7-25
HYBRID_HASH_SEMI_JOIN Operator 7-26
INDEX_SCAN Operator 7-27
INDEX_SCAN_UNIQUE Operator 7-29