Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6.1 - User Guide

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


Denotes operation where DB2 sorts qualified index entries.



Use to perform a star join.

Star join allows you to join a dimension column of a fact table to the key column in the corresponding dimension table.



Use to read every row in a table.

A table space scan construct consists of two nodes: a TBSCAN node and some type of table node such as a base table, a materialized query table, a work file, a pipe, or a table function.



Denotes TRUNCATE statement.

A TRUNCATE statement deletes all rows for either declared global temporary tables or base tables.


Related Documents