statistic - Advanced SQL Engine - Teradata Database

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.