Analysis Summary
The Analysis Summary window shows a summary of the analysis recommendation.
Figure 12: Example of Analysis Summary for Index AnalysisTo view the analysis summary
1 Click View>Analysis Summary.
The Analysis Summary window opens. The following table explains the information in the window.
2 Click OK to close the Analysis Summary window.
Option |
Description |
Server Name |
Displays the server name where the analysis is performed. |
QCD Name |
Displays the QCD name. |
Workload |
Shows the workload name. |
Recommendations ID |
Displays the recommendations ID. |
Start Time |
Start time of the analysis. |
End Time |
End time of the analysis. |
Time Limit Expired |
Displays information about the time limit specified during the analysis. The Time Limit Expired value can be the following: |
Number of tables considered in the analysis. |
Shows the number of tables analyzed. |
Numbers of tables on which indexes where recommended. |
Shows the number of table that received an index recommendation. |
Number of table on which indexes exist |
Shows the number of table that have an index. |
Number of statements considered for analysis |
Shows the number of statements that where considered for analysis. |
Total elapse time |
Shows the total time taken by Index Wizard for the analysis. |