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

SQL Optimizer for DB2 ZOS 5.6.2 - User Guide

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

MERGESTMT

Denotes the MERGE statement.

This node merges the conditional UPDATE and INSERT operation on a target table or view into one statement.

 

MIXSCAN

Scan a multiple-index.

 

MSJOIN

Use to perform a merge join.

 

NLJOIN

Use to perform a nested loop join.

This join is used to join tables and is represented by a NLJOIN node and right and left subtrees. The inner table is represented by the right subtree and the outer table by the left subtree. Use either a single-index scan, a multiple-index scan, or a table space scan to access both the inner and outer tables. You can also include another join operation with the left subtree.

 

관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택