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.
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.
|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.|
|join index||STATISTICS||the join index.|
|hash index||STATISTICS||the hash index.|