Validation Results - Teradata Index Wizard

Teradata Index Wizard User Guide

Product
Teradata Index Wizard
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2506
Product Category
Teradata Tools and Utilities

The Validation Results window:

  • Shows the results of the validation and the query IDs of the statements before and after validation.
  • Shows the system where the recommendations were made and the system where the validation was completed, along with the overall cost difference in executing the workload before and after validation.
  • Displays the details of the tables involved in validation, their cardinalities and the statistic sample size considered for validation.
  • The following table explains the information in the Validation Results window.

     

    Table 30: Validation Results Window Description 

    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.

  • The Validation Process
  • Loading Recommendations from QCD
  • Loading Recommendations from File