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


Denotes a work file or temporary table that DB2 generates.

DB2 labels a work file node with the word WORKFILE or with specific name. Sort (for JOIN, UNION, DISTINCT, GROUP BY, or ORDER BY operations) is the most common operation for generating work files.



Denotes operation where DB2 returns intersection of two sorted DOCID lists. Output includes only DOCIDs in both lists.



Denotes operation for XML data where DB2 returns the union of two sorted DOCID lists.

The output includes any DOCID that exists in at least one of the DOCID lists and removes duplicate DOCIDs.



Access and scan an XML index.

This operation returns DOCID and NODWID pairs.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating