DROP STATISTICS

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.

Example

DROP STATISTICS Music.ArtistTbl.ArtistStats, Sales.SalesTbl.SalesStats;

"There are lies, damned lies, and statistics" ~ Disraeli

Related commands:

CREATE STATISTICS
Equivalent Oracle command: DISSASSOCIATE STATISTICS


© Copyright SS64.com 1999-2014
Some rights reserved