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.
- Name of the index.
- The index for which statistics are to be dropped is unique.
- ALL was used to create the index.
- Names of one or more columns on which the index exists and for which statistics are to be dropped.
Example: Dropping Statistics on a Composite Index
This request drops statistics on a composite index defined on the emp_no and name columns of the employee table.
DROP STATISTICS INDEX(emp_no, name) ON employee;
Example: Dropping Statistics on a Named Index
This example drops any statistics on an index named unique_1.
DROP STATISTICS INDEX unique_1 ON table_1;
Example: Dropping Statistics on an Unnamed Index
This example drops any statistics on an unnamed composite index defined on column_1 and column_2.
DROP STATISTICS INDEX (column_1,column_2) ON table_1;