サポートと今すぐチャット
サポートとのチャット

SQL Optimizer for DB2 ZOS 5.6 - User Guide

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

CORSUB

Welcome > SQL Operations > CORSUB

Use a correlated subquery for access.

The CORSUB operation provides access by a correlated subquery.

 

DELCUR

Welcome > SQL Operations > DELCUR

Perform a DELETE WHERE CURRENT OF CURSOR operation.

 

DELETE

Welcome > SQL Operations > DELETE

Remove rows from a table or view.

A delete construct contains a DELETE node and one of the following: table space scan, single-index access, or multiple-index access.

 

DFETCH

Welcome > SQL Operations > DFETCH

Represents a direct fetch data using ROWID.

ROWID is used as a search condition. This is the most efficient was to access a base table if a ROWID-type column is defined within the table.

 

関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択