SQL Optimizer for IBM DB2 z/OS Help
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
- 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
- Tutorial
- About us
- Copyright