Index Recommendations

Use the Index Recommendations dialog box to view the recommendations made by the Index Tuning Wizard. This dialog box

Displays the recommended index set. The list may contain existing indexes to use, existing indexes to drop, or new indexes to be created.

Options

Clustered

Indicates whether the index is clustered.

Index Name

Displays the name of the index. An icon representing the status of the index (existing, new, or to be dropped) is displayed. To view the icon definition, click the icon.

Table/View Name

Displays the table or view associated with the index.

Column Name

Displays the columns used in the index.

Analysis

Click to open the Reports dialog box.