17.00 - statistic - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)
Last Update
2021-01-23

Named index for which statistics are to be dropped.

This does not drop SUMMARY statistics for the specified index. To drop SUMMARY statistics on a database object, you must drop all statistics for the object.

Note that you specify column names with a named index only when it is defined with an ORDER BY clause.

UNIQUE
The index for which statistics are to be dropped is unique.
index_name
Name of the index.
ALL
ALL was used to create the index.
column_name_1
Names of one or more columns on which the index exists and for which statistics are to be dropped.
ORDER BY
ORDER BY was used to create the index.
ORDER BY orders the index by the contents of a single column. If you specify ORDER BY but not VALUES or HASH, then VALUES is assumed.
VALUES
ORDER BY VALUES was used to create the index.
VALUES can order a single numeric column of four bytes or less.
HASH
ORDER BY HASH was used to create the index.
HASH hash-orders a single column instead of hash-ordering all columns (the default).
column_name_2
Name of a column on which the index was ordered.