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
Select an index set in the Alternatives pane.
Tip: Click to test run all index alternatives.
Select a storage group in which to store the created indexes. (missing or bad snippet)
|Index||Shows SQL text of index selected.|
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.