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

SQL Optimizer for DB2 ZOS 5.6.2 - User Guide

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

IXAND

Represents the intersection of two sorted ROWID lists. Output includes only ROWIDs in both lists.

 

IXOR

Return the union of two sorted ROWID lists.

Output includes any ROWID that is present in at least one ROWID list. The output removes duplicate ROWIDs.

 

IXSCAN

Use an index to retrieve the rows.

 

MERGE

Merge multiply data streams into a single data stream.

 

관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택