Converse agora com nosso suporte
Chat com o suporte

SQL Optimizer for DB2 ZOS 5.5.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Copyright

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.

 

RETURN

Auxiliary node that represents an entire SQL statement.

Labeled QUERY, this node can represent any of the following operations:

  • MERGE
  • INSERT
  • SELECT
  • UPDATE
  • DELETE

 

Documentos relacionados

The document was helpful.

Selecione a classificação

I easily found the information I needed.

Selecione a classificação