지금 지원 담당자와 채팅
지원 담당자와 채팅

SQL Optimizer for DB2 ZOS 5.6 - User Guide

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

DIXSCAN

Welcome > SQL Operations > DIXSCAN

Represents access by XML DOCID index scan.

 

EXCEPT

Welcome > SQL Operations > EXCEPT

Denotes the EXCEPT operation.

This operation returns rows in the outer table only and eliminates redundant duplicate rows.

 

EXCEPTA

Welcome > SQL Operations > EXCEPTA

Denotes the EXCEPT ALL operation.

This operation returns rows in the outer table only and retains redundant duplicate rows.

 

FETCH

Welcome > SQL Operations > FETCH

Represents the retrieval of columns for a row.

The FETCH operator uses RIDs from an IXSCAN or MIXSCAN.

 

관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택