documentation
.HELP!
SQL Optimizer for IBM DB2 z/OS Documentation
MIXSCAN
SQL Optimizer for IBM DB2 z/OS
previous page
next page
MIXSCAN
Scan a multiple-index.
previous page
start
next page
Menu
Homepage
Table of contents
Welcome
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
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
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
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
Copyright
Get in touch
Submit feedback about this site to:
[email protected]