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:
- “ALTER TABLE”, “CREATE INDEX”, “CREATE JOIN INDEX”, “DROP INDEX”, and “DROP JOIN INDEX” in SQL Data Definition Language - Syntax and Examples, B035-1144
- “COLLECT STATISTICS (QCD Form)”
- “DROP STATISTICS (QCD Form)”
- “INITIATE INDEX ANALYSIS”
- “INITIATE PARTITION ANALYSIS”
- INSERT EXPLAIN
Required Privileges
None.
Syntax
Syntax Elements
- NOT ON
- Disabled for the session.
- ON
- Enabled for the session.
- FOR SESSION
- Set at the session scope level.
ANSI Compliance
DIAGNOSTIC “validate index” is a Teradata extension to the ANSI SQL:2011 specification.