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

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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.