15.10 - The Validation Process - Teradata Index Wizard

Teradata Index Wizard User Guide

prodname
Teradata Index Wizard
vrm_release
15.10
category
User Guide
featnum
B035-2506-035K

Validation can be done in any of the following ways:

  • Analysis performed on the production system and validated on the production system.
  • Analysis performed on the test system and validated on the production system.
  • Analysis performed on the production system and validated on the test system.
  • Analysis performed on the test system and validated on the test system.
  • Note: It is recommended that the last two options not be used during validation because the collected statistics are from the local system and a test system is usually an emulated production system where the table data does not exist.

    When the analysis and validation are performed on the same system, you can select the recommendations from the QCD and leave the Validate on Another System unchecked.

    When the analysis is performed on one system (test system) and the validation is performed on another system (production system), the following scenarios can occur:

  • The user is logged on to the system where the workload is analyzed and wants to validate on another system. In this case, check the Validate on Another System option in the Load Recommendations from QCD window to log on to the system on which validation must be done. Additionally, the recommendations can be loaded using either the QCD or the file, if they were saved at the time of analysis.
  • The user is logged on to the system where the validation is to be performed. In this case, the recommendations can be loaded from QCD (if the analysis results are available on this system by importing of the recommendations earlier) or from the file that was saved at the time analysis was performed.
  • Loading Recommendations from QCD
  • Loading Recommendations from File
  • Validation Results