View Details Button
Access the View Details button from the Select Workload dialog box or from the What-If Analysis dialog box using the Add System Recommendations button.
From the Reports tab, view the workload details including reports for Workload Statements, Workload Analysis, Table Scan, and Existing Indexes. Select one or more check boxes, click View, and the reports display.
From the System Recommendations tab, view the system recommendations in case the workload was analyzed earlier. The recommendations are read-only.
To view the statement text
✔ In the View Details dialog box, right-click any statement and click View DDL.
The View Statement dialog box appears and displays the complete index/statistics DDL text.