15.10 - INDEX - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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.

index_name
Name of the index.
UNIQUE
The index for which statistics are to be dropped is unique.
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.

Example: Dropping Statistics on a Composite Index

This request drops statistics on a composite index defined on the emp_no and name columns of the employee table.

     DROP STATISTICS INDEX(emp_no, name) ON employee;

Example: Dropping Statistics on a Named Index

This example drops any statistics on an index named unique_1.

     DROP STATISTICS INDEX unique_1 ON table_1;

Example: Dropping Statistics on an Unnamed Index

This example drops any statistics on an unnamed composite index defined on column_1 and column_2.

     DROP STATISTICS INDEX (column_1,column_2) ON table_1;