Diagnostic Tools for Target Level Emulation and the Teradata Index Wizard - Teradata Database

SQL Data Manipulation Language

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
psg1480972718197.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
Teradata® Database

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.