Drop index stats in Teradata

An index can be named or unnamed i.e defined index. To drop the stats on an index following syntax can be used in teradata,

DROP STATISTICS INDEX index_name ON table_name;
DROP STATISTICS ON table_name INDEX index_name;

Note : The above code throws error, if a index does not exist with a name index_name.

To drop stats on defined index i.e when no name is specified for index
DROP STATISTICS INDEX (col1,col2) ON table_name;
DROP STATISTICS ON table_name INDEX (col1,col2);

In the above instance, table_name has index as col1,col2