Drop statistics in the current database (for one or more collections within the table)
Syntax DROP STATISTICS table.statistics [ ,...n ] DROP STATISTICS view.statistics [ ,...n ] Key table/view The item for which statistics should be dropped statistics The name of the statistics group to drop
To drop statistics on an index, drop and rebuild the index.
DROP STATISTICS Music.ArtistTbl.ArtistStats, Sales.SalesTbl.SalesStats;
"There are lies, damned lies, and statistics" - Disraeli
Equivalent Oracle command: