SQL Optimizer for DB2 ZOS 5.6.2

Chat now with support

Live-Hilfe anfordern
Registrierung abschließen

Anmelden

Preisinformationen anfragen

Vertrieb kontaktieren

About SQL Optimizer About Product Improvement Program Connections Connect to the Database SQL Optimization Workflow Create Support Bundles Join the SQL Optimizer Community Product Licensing Additional Resources SQL Operations

BTBSCAN CORSUB DELCUR DELETE DFETCH DIXSCAN EXCEPT EXCEPTA FETCH FFETCH FIXSCAN HBJOIN HSSCAN INLIST INSERT INTERSECT INTERSECTA IXAND IXOR IXSCAN MERGE MERGESTMT MIXSCAN MSJOIN NLJOIN PARTITION PIXSCAN PRUNED QB RETURN REPARTITION RGLIST RIDFETCH SELUPD SEMIJOIN SIXSCAN SORT SORTRID STARJOIN TBSCAN TRUNCATE UNION UNIONA UPDATE UPDCUR WFSCAN WORKFILE XIXAND XIXOR XIXSCAN

Optimize SQL

About Optimizing SQL Create Optimize SQL Sessions Open Optimizer SQL Sessions Optimize SQL Statements Specify Session Test Run Criteria Automatically Optimize SQL Statements Execution Plan

About Execution Plans Review Execution Plans Get Execution Plans Fill Missing Execution Plans Copy Execution Plans Generate Execution Plan Alternatives Compare Execution Plan Alternatives Execute Execution Plan Alternatives Retrieve Run Results Deploy Plan Guides Animate Execution Plans

Generate Index Alternatives

About Generating Index Alternatives Test Run Index Alternatives Generate Index Alternatives Delete Remaining Indexes

Test Run SQL Alternatives Retrieve Run Results Create User Defined Alternatives Set Bind Variables Review Alternatives Alternative SQL Text View Optimization Details View Schema Information View Bind Variables Show or Hide Table Attributes Show or Hide Column Attributes Compare SQL Statements Generate Optimize SQL Resolution Report Troubleshoot Optimization Results

Options

General

Execution Plan Options Directory Setup Options Appearance Options

Optimize SQL

SQL Rewrite

Intelligence Options Optimization Options SQL Options Quota Options

Index Generation

Index Options Intelligence Options (Index Generation)

Test Run

Test Run Options Execution Method Options Order and Termination Options Best Alternative Criteria Options

Tutorial

Tutorial: SQL Optimizer

About us Third-party contributions Copyright

INLIST

Welcome > SQL Operations > INLIST

Denotes the in-memory table that stores IN-list elements.

INSERT

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

Welcome > SQL Operations > INTERSECT

Denotes the INTERSECT operation.

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

INTERSECTA

Welcome > SQL Operations > INTERSECTA

Denotes the INTERSECT ALL operation.

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

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen

Bitte w&auml;hlen Sie Ihr Produkt aus:

Damit wir Ihnen besser helfen können, geben Sie den Grund Ihres Chats an:

Empfohlene Lösungen für Ihr Problem

SQL Optimizer for DB2 ZOS 5.6.2 - User Guide

INLIST

INSERT

INTERSECT

INTERSECTA

Bitte wählen Sie Ihr Produkt aus: