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. |