The Validation Results window:
The following table explains the information in the Validation Results window.
|
Window Option |
Description |
|
Sample Size area |
|
|
Table Name |
Displays the name of the table where the recommendation is made. |
|
Cardinality |
Displays the cardinality of the table. |
|
% Sample on which statistics were collected |
Displays the percentage of the sample where the statistics were collected for the recommended index. |
|
Results area |
|
|
Query ID (without recommendations) |
Displays the query ID before index validation. |
|
Query ID (with recommendations) |
Displays the query ID after validation. |
|
% Cost Improvement |
Displays the percentage cost improvement of the statements after index validation. |
|
Index Type |
Displays the type of index used during index validation. |
|
Simulated Index Used |
Simulated Index gives information about whether the recommended index is used for that particular query ID or not. Simulated Index Used can be YES or NO. A YES indicates that the recommended index is used in the execution of that query ID. A NO indicates that the recommended index is not used in the execution of the query ID. |
|
Statement Text |
Displays the text of the SQL statement. |
|
Source System |
Displays the system name where the analysis was performed along with the QCD name. |
|
Validated System |
Displays the system name where the validation was performed along with the QCD name. |
|
Conclusion |
Displays the average cost of queries that used simulated indexes. |
|
Compare |
Opens Teradata Visual Explain and visually compares the plans selected in the results grid. |
|
View Graph |
Generates the graph displaying the execution cost of the statements before and after the validation. The graph shows a statement-wise comparison of the estimated query costs. |
|
View Details |
Displays the information on which table index is created, type of index, and statistics information of the index. |