Drops statistics for the specified table and index.
Syntax
DROP STATISTICS ON < table_name > [ . <index_name> ]
Arguments
-
table_name
-
Specifies the name of the table to drop the statistics from.
-
index_name
-
The index to drop the statistics from. If no index is specified, the statistics are dropped for all indexes in the table.
Example
The following example demonstrates how to drop an index, create an index, and drop statistics for a specified table and index.
DROP INDEX Orders.emp_id_ind;
CREATE INDEX emp_id_ind ON Orders ([Employee ID]);
DROP STATISTICS ON Orders.emp_id_ind;