Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6.1 - Installation Guide

About Generating Index Alternatives

SQL Optimizer analyzes the following in your original SQL statement and table references to generate index alternatives:

  • SQL statement syntax
  • Related tables and indexes
  • Search arguments
  • Table join conditions

Once SQL Optimizer generates alternatives, you can test them to evaluate improvements in database performance.

Note: SQL Optimizer does not physically create indexes on your database when generating alternatives.

 

Related Topics

Test Run Index Alternatives

Generate Index Alternatives

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating