Chat now with support
Chat mit Support

SQL Optimizer for DB2 ZOS 5.6 - User Guide

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

FFETCH

Welcome > SQL Operations > FFETCH

Employs a fact table index in order to fetch a fact table in a data manager pushdown star join.

 

FIXSCAN

Welcome > SQL Operations > FIXSCAN

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

 

HBJOIN

Welcome > SQL Operations > HBJOIN

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.

 

HSSCAN

Welcome > SQL Operations > HSSCAN

Use to perform a HASH SCAN.

 

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen