documentation.HELP! SQL Optimizer for IBM DB2 z/OS Documentation

IXSCAN

SQL Optimizer for IBM DB2 z/OS

previous page next page

IXSCAN

Use an index to retrieve the rows.

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
Options
- General
- Optimize SQL
Tutorial
- Tutorial: SQL Optimizer
About us
Copyright

Get in touch

Submit feedback about this site to:

[email protected]

© documentation.help. Design: rehmann.co.