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

SQL Optimizer for DB2 ZOS 5.6 - User Guide

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

IXAND

Welcome > SQL Operations > IXAND

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

 

IXOR

Welcome > SQL Operations > 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

Welcome > SQL Operations > IXSCAN

Use an index to retrieve the rows.

 

MERGE

Welcome > SQL Operations > MERGE

Merge multiply data streams into a single data stream.

 

관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택