DISASSOCIATE STATISTICS

Disassociate a type of statistics (or default statistics) with an object.


Syntax:

   DISSASSOCIATE STATISTICS FROM object [schema.]object_name [FORCE]

Where object is any of
   COLUMNS
   FUNCTIONS
   PACKAGES
   TYPES
   INDEXES
   INDEXTYPES

More than one object of the same type can be disassociated in a single statement if separated with commas.
e.g.
DISASSOCIATE STATISTICS FROM PACKAGES pkg_emp.start, pkg_emp.finish ;

DISASSOCIATE... FORCE will automatically delete statistics where necessary.

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

Related Commands:

DBMS_STATS
EXPLAIN PLAN
IMP with rows=y
STATISTICS - ASSOCIATE STATISTICS

Related Views:

 DBA_PART_COL_STATISTICS  ALL_PART_COL_STATISTICS USER_PART_COL_STATISTICS 
 DBA_TAB_COL_STATISTICS   ALL_TAB_COL_STATISTICS  USER_TAB_COL_STATISTICS 

 V$BUFFER_POOL_STATISTICS