FREE TRIALS

SQL Optimizer for DB2 ZOS 5.0 - User Guide

Table of Contents

About SQL Optimizer Connect to the Database SQL Optimization Workflow Create Support Bundles Join the SQL Optimizer Community Register SQL Optimizer 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

About Optimizing SQL Create Optimize SQL Sessions Open Optimizer SQL Sessions Select Connection 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 Animate Execution Plans

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

About Options General

General Options Execution Plan Options Directory Setup Options Appearance Options

Intelligence Options Optimization Options SQL Options Quota Options

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

Tutorial: SQL Optimizer

XIXAND

Denotes operation where DB2 returns intersection of two sorted DOCID lists. Output includes only DOCIDs in both lists.

XIXOR

Denotes operation for XML data where DB2 returns the union of two sorted DOCID lists.

The output includes any DOCID that exists in at least one of the DOCID lists and removes duplicate DOCIDs.

XIXSCAN

Access and scan an XML index.

This operation returns DOCID and NODWID pairs.

Optimize SQL

The Optimize SQL function analyzes the input SQL statement and uses an Artificial Intelligence Engine to produce a group of semantically equivalent versions of the statement, known as SQL alternatives. You can then test run these alternatives in the SQL Optimizer window to determine the best-performing version of the SQL.

Note: The Intelligence Level setting you select affects the duration of the optimization process and the number of alternatives SQL Optimizer generates.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating