statistic
Named index for which statistics are to be dropped.
This does not drop SUMMARY statistics for the specified index. To drop SUMMARY statistics on a database object, you must drop all statistics for the object.
Note that you specify column names with a named index only when it is defined with an ORDER BY clause.
- UNIQUE
- The index for which statistics are to be dropped is unique.
- index_name
- Name of the index.
- ALL
- ALL was used to create the index.
- column_name_1
- Names of one or more columns on which the index exists and for which statistics are to be dropped.
- ORDER BY
- ORDER BY was used to create the index.
- VALUES
- ORDER BY VALUES was used to create the index.
- HASH
- ORDER BY HASH was used to create the index.
- column_name_2
- Name of a column on which the index was ordered.
indexed_item
- TEMPORARY
- Statistics are to be dropped for a materialized global temporary table.
- database_name
- Containing database for table_name, join_index_name, or hash_index_name if something other than the current database.
- user_name
- Containing user for table_name, join_index_name, or hash_index_name if something other than the current database.
- table_name
- Name of one of the following database objects whose statistics are to be dropped.
- Table or global temporary table
- Single-table view
You can only request HELP STATISTICS reports for single-table views.
- Single-table query
You can only request HELP STATISTICS reports for single-table queries.
- join_index_name
- Name of the join index for which column or index statistics are to be dropped.
- hash_index_name
- Name of the hash index for which column or index statistics are to be dropped.
column_index
- column_name
- Names of the columns for which statistics are to be dropped.
- expression
- Column expression that was used to collect the statistics to be dropped.
- statistics_name
- Name of the statistics collected on column_name.
- PARTITION
- Column partition statistics are to be dropped.