15.10 - DROP STATISTICS (Optimizer Form) - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
Release Date
December 2015
Content Type
Programming Reference
Publication ID
English (United States)


Drops the statistical data that was collected for the specified columns of a table, hash index, or join index by a COLLECT STATISTICS (Optimizer Form) request. The only way to drop the SUMMARY statistics for a database object is to drop all statistics on that object.

Required Privileges

To DROP STATISTICS on a … You must have this privilege … On …
permanent or base global temporary table STATISTICS the table.
materialized global temporary table none. none.
volatile table none. none.
join index STATISTICS the join index.
hash index STATISTICS the hash index.