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
Select an index set in the Alternatives pane.
Click 
Tip: Click 
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. | |
