The Optimize Now window displays the script that used to enact the recommended change.
Review the script, and then either click the Run button to initiate the optimization or click Cancel to return to the recommendation you were viewing.
| Tip |
|---|
When you run the optimize script, a  Image Added displays next to the optimized recommendation. |
You can also copy the script to Notepad or another text editor to examine the code and research other options further before making the change.
...
To access the Optimize Now window, view the list of recommendations for a SQL Server instance. Select the appropriate row, and then click Optimize Script.