立即与支持人员聊天
与支持团队交流

SQL Optimizer for DB2 ZOS 5.5.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Copyright

SEMIJOIN

Use to perform a semi join.

During a hybrid join, this node denotes a join operation where the outer table records merge with one of the indexes on the inner table.

 

SIXSCAN

Access and scan with a sparse index.

A sparse index scan construct contains two nodes: a SIXSCAN node and a sparse index node labeled SPARSE INDEX.

 

SORT

Sort result set in the order specified from the join process or the query.

 

SORTRID

Denotes operation where DB2 sorts qualified index entries.

 

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级