Diagnostic Tools for Target Level Emulation and the Teradata Index Wizard
Introduction
This section documents requests used for various Target Level Emulation applications.
See SQL Request and Transaction Processing for more information about Target Level Emulation.
Diagnostic Statements for Random‑AMP Sample‑Based Target Level Emulation
To work with table information obtained from random AMP sample statistics collected on a production system, see the descriptions of the following statements:
Diagnostic Statement for Setting Index Validation Mode/Validating Indexes
The “DIAGNOSTIC “Validate Index”” statement sets the index validation mode for Target Level Validation and then validates the indexes proposed by the Teradata Index Wizard.