DROP STATISTICS SQL Statement | Teradata Vantage - 17.05 - DROP STATISTICS (Optimizer Form) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Other SQL dialects support similar non-ANSI standard statements with names such as DISASSOCIATE STATISTICS.

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.