SQL Optimizer for DB2 ZOS 5.6 - User Guide

PARTITION

Separate a single data stream into multiple data streams.

PIXSCAN

Scan Dynamic Pair-Wise Index.

PRUNED

No access path is generated for the query since the query only qualifies zero rows.

QB

Auxiliary node that represents a subquery in a particular SQL statement.

A subquery can be any of the following operations:

• MERGE
• INSERT
• SELECT
• UPDATE
• DELETE
• SELECT with FOR UPDATE OF
• UPDATE WHERE CURRENT OF CURSOR
• DELETE WHERE CURRENT OF CURSOR
• TRUNCATE
• Table expression
• Correlated subselect or full select
• Non-correlated subselect or fullselect
• EXCEPT
• EXCEPT ALL
• EXCEPT
• EXCEPT ALL
• UNION
• UNION ALL

Notes:

• The query block node is the root of a subtree and represents the whole subquery.
• QBn denotes a query block node,where n represents the query block number.