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

SQL Optimizer for DB2 ZOS 5.6.2 - User Guide

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

WFSCAN

Scan a work file.

A work file scan construct contains a WFSCAN node plus a work file node that is labeled WORKFILE.

 

WORKFILE

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.

 

XIXAND

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

 

XIXOR

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.

 

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级