Tchater maintenant avec le support

Obtenir une aide instantanée
Terminer l’enregistrement

Se connecter

Demander les tarifs

Contacter le service des ventes

SQL Optimizer for DB2 ZOS 5.5.1 - User Guide

Parcourir le contenu

About SQL Optimizer Connections 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 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

Generate Index Alternatives

About Generating Index Alternatives Test Run Index Alternatives Generate Index Alternatives

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

Execution Plan Options Directory Setup Options Appearance Options

Intelligence Options Optimization Options SQL Options Quota Options

Index Generation

Index Options Intelligence Options (Index Generation)

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

Tutorial: SQL Optimizer

About us Copyright

SEMIJOIN

Use to perform a semi join.

During a hybrid join, this node denotes a join operation where the outer table records merge with one of the indexes on the inner table.

SIXSCAN

Access and scan with a sparse index.

A sparse index scan construct contains two nodes: a SIXSCAN node and a sparse index node labeled SPARSE INDEX.

SORT

Sort result set in the order specified from the join process or the query.

SORTRID

Denotes operation where DB2 sorts qualified index entries.

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation

© ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center