DIAGNOSTIC “Validate Index” - 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

Purpose

Enables or disables the index and partition validation mode for the session and validates the indexes and partitioning expressions proposed by the Teradata Index Wizard utility.

Alternatively, you can use the statement to evaluate user-specified indexes and partitioning expressions.

For more information about the Teradata Index Wizard, see SQL Request and Transaction Processing.

For more information about how to use the client utility, see Teradata Index Wizard User Guide .

Also see the documentation for the following Index Validation-related SQL statements:

Required Privileges

None.

Syntax



Syntax Elements

NOT ON
Disabled for the session.
ON
Enabled for the session.
When validation mode is turned ON, you can issue any of the following statements to simulate the existence (or nonexistence) of indexes and partitioning expressions for validation without actually creating or altering them.
  • ALTER TABLE … MODIFY PRIMARY INDEX
  • COLLECT STATISTICS (QCD Form)
  • CREATE INDEX
  • CREATE JOIN INDEX
  • DROP INDEX
  • DROP JOIN INDEX
  • DROP STATISTICS (QCD Form)
  • INSERT EXPLAIN
FOR SESSION
Set at the session scope level.
No other diagnostic scope levels are valid.

ANSI Compliance

DIAGNOSTIC “validate index” is a Teradata extension to the ANSI SQL:2011 specification.