The Analysis Summary window shows a summary of the analysis recommendation.
Figure 12: Example of Analysis Summary for Index Analysis
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. |