立即与支持人员聊天
与支持团队交流

SQL Optimizer for DB2 ZOS 5.6.1 - Release Notes

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

Generate Index Alternatives

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级