ASSOCIATE STATISTICS

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

Syntax:

   ASSOCIATE STATISTICS WITH
      COLUMNS [schema.]table_column,...
         USING [schema.]statistics_type;

   ASSOCIATE STATISTICS WITH
      object [schema.]object_name,...
         cost_usage_clause;

Where object is any of
   
   FUNCTIONS
   PACKAGES
   TYPES
   INDEXES
   INDEXTYPES

cost_usage_clauses:
   USING [schema.]statistics_type
   DEFAULT COST (cpu_cost, io_cost, network_cost)
   DEFAULT SELECTIVITY default_selectivity

"There are lies, damned lies, and statistics." - Mark Twain

Related Commands:

ANALYZE
EXPLAIN PLAN

IMP with rows=y
STATISTICS - DISASSOCIATE 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 




Back to the Top

Simon Sheppard
SS64.com