15.10 - DROP STATISTICS (Optimizer Form) - 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

Purpose

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.

Syntax