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 Oracle 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