The Recommendations tab appears after Database Engine Tuning Advisor completes analysis of a workload. This grid contains the recommendations for each object considered. Partition recommendations, if any, are presented in the upper grid, and the index recommendations are presented in the lower grid. The grids do not appear if there are no recommendations.
The Definition column contains the definition of the recommended partition or index as a hyperlink. This column is usually too narrow to see the entire definition. Click the hyperlink to display a dialog box containing the full definition and the Copy to Clipboard button.
The database containing the objects recommended to be modified.
The action recommended to improve performance. Possible values are Create and Drop.
Target of Recommendation
The partition function or scheme affected by the recommendation. The icon in this column reflects the recommendation to drop or add the Target of Recommendation and whether it is a partition function or scheme.
A description of the Target of Recommendation. Possible values include a range for partition functions, or blank for partition schemes.
No. of Partitions
The number of partitions defined by the recommended partitioning functions. When this function is used with a scheme and then applied to a table, the data in the table is divided into that many partitions.
The definition of the Target of Recommendation. Click the column to open the SQL Script Preview dialog box, with a script for the recommended action.