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