Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6.1 - Installation Guide

Test Run Index Alternatives

After SQL Optimizer generates index alternatives, you can test each alternative. When SQL Optimizer tests indexes, the indexes are physically created on the database and dropped after SQL Optimizer executes the statement. When you test run index alternatives, you must select a storage group in which to store the created indexes.

(missing or bad snippet)

To execute index alternatives

  1. (missing or bad snippet)
  2. Select a SQL Rewrite session.
  3. Select an index set in the Alternatives pane.

  4. Click .

    Tip: Click to test run all index alternatives.

  5. Select a storage group in which to store the created indexes. (missing or bad snippet)

    Index Information Description
    Index Shows SQL text of index selected.
    Storage group

    Storage group to store indexes created.

    Note: Once you select the storage group for the first index, SQL Optimizer automatically selects the same storage group for the remaining indexes.

    Note: Review the information in the DDL Script pane.

 

Related Topic

Generate Index Alternatives

Related Documents