DROP STATISTICS SQL Statement | Teradata Vantage - 17.00 - 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
September 2020
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.

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.