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