Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Third-party contributions Copyright

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.

 

Related Documents