Drops the statistical data that was collected for specified columns of a table 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
| Item on Which to DROP STATISTICS | Privilege Needed |
|---|---|
| Permanent or base global temporary table | STATISTICS on the table |
| Materialized global temporary table | None |
| Volatile table | None |
| Join index | STATISTICS on the join index |