16.20 - DROP STATISTICS (Optimizer Form) - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

Purpose

Drops the statistical data that was collected for specified columns of a table, hash index, or join index by a COLLECT STATISTICS (Optimizer Form) request. To drop the SUMMARY statistics for a database object, 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