Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6.1 - Release Notes

Generate Index Alternatives

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To generate index alternatives for a SQL statement

  1. Select the SQL Details tab in the main window.
  2. Enter the SQL statement in the Alternative Details pane.
  3. Click Index button.

Note: Delete Remaining Indexes Window may appear if it has been detected that some virtual/real indexes exist in the database and these might affect index searching result. It is recommended to remove the unused indexes before starting the search.

  1. Select Index Details in the SQL Information pane to view index generation information.

    Tip: Click to stop the index generation process.

Note: When you generate virtual index alternatives, the execution plan is not retrieved for the SQL statement because SQL Optimizer does not physically create indexes on the database. Fill Missing Execution Plans

 

Related Topics

Test Run Index Alternatives

Related Documents