Chat now with support
Chat mit Support

SQL Optimizer for DB2 ZOS 5.5.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Copyright

INSERT

Insert rows into table or view.

The insert construct contains two nodes: one INSERT node and one node that represents either the target view or table.

 

INTERSECT

Denotes the INTERSECT operation.

This node returns rows in both the inner and outer tables and eliminates redundant duplicate rows.

 

INTERSECTA

Denotes the INTERSECT ALL operation.

This node returns rows in both the inner and outer tables and retains redundant duplicate rows.

 

IXAND

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

 

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen