Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.5.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Copyright


Represents a fact table index scan in a data manager pushdown star join.



Use to perform a hybrid join.

A hybrid join is used only on inner joins. The construct contains a single HBJOIN node and two subtrees.



Use to perform a HASH SCAN.



Denotes the in-memory table that stores IN-list elements.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating