지금 지원 담당자와 채팅
지원 담당자와 채팅

SQL Optimizer for DB2 ZOS 5.6 - User Guide

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

PARTITION

Welcome > SQL Operations > PARTITION

Separate a single data stream into multiple data streams.

 

PIXSCAN

Welcome > SQL Operations > PIXSCAN

Scan Dynamic Pair-Wise Index.

 

PRUNED

Welcome > SQL Operations > PRUNED

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

 

QB

Welcome > SQL Operations > 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.

 

관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택