On the Analyze tab, in the Scripts group, you can identify a problem and optimize performance:
Show Problem
The Show Problem button launches the SQL Viewer window with the SQL text associated with the recommendation highlighted. Click Copy to copy the SQL text to the clipboard so you can view the text in a text editor or in SQL Server Management Services.
Optimize Script
The Optimize Script window displays the script that is 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. 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.
Undo Script
The Undo Script window displays the script that is used to enact the recommended change. Review the script, and then either click the Run button to initiate the undo or click Cancel to return to the recommendation you were viewing. The undo script can be copied to clipboard and used at a later time.