Page History

...

The following information is displayed in the Recommend tab:■    Recommended

• Recommended Index/Statistics

...

• Recommendation details

About viewing Recommended Indexes/Statistics

Displays the recommended indexes or statistics, as follows:■    Icon—indicates

• Icon. Indicates whether the item is a recommended index or statistic.

...

• Table. Displays the name of the table to which the recommendation refers.

...

• Unique. Indicates whether the index is unique. This value is not relevant for recommended statistics.

...

• Clustered. Indicates whether the index is clustered. This value is not relevant for recommended statistics.

...

• Columns List. Displays a list of the index's or statistic's columns separated by commas. The sort order (ASC, DESC) is also displayed for recommended indexes.

About viewing Recommendation details

Displays details on the recommended index or statistic. The following tabs are available:

...