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