Test Run Index Alternatives

SQL Optimizer for IBM DB2 z/OS

Test Run Index Alternatives

After SQL Optimizer generates index alternatives, you can test each alternative. When (Undefined variable: CommonVariables.product_name) 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

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

Tip: Click to test run all index alternatives.

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, (Undefined variable: CommonVariables.product_name) automatically selects the same storage group for the remaining indexes.
Note: Review the information in the DDL Script pane.

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, (Undefined variable: CommonVariables.product_name) automatically selects the same storage group for the remaining indexes.

Note: Review the information in the DDL Script pane.