ASSOCIATE STATISTICS WITH
{ column_association | function_association }
[ storage_table_clause ] ;
column_association::=
COLUMNS [ schema. ]table.column
[, [ schema. ]table.column ]...
using_statistics_type
function_association::=
{ FUNCTIONS
[ schema. ]function [, [ schema. ]function ]...
| PACKAGES
[ schema. ]package [, [ schema. ]package ]...
| TYPES
[ schema. ]type [, [ schema. ]type ]...
| INDEXES
[ schema. ]index [, [ schema. ]index ]...
| INDEXTYPES
[ schema. ]indextype [, [ schema. ]indextype ]...
}
{ using_statistics_type
| { default_cost_clause [, default_selectivity_clause ]
| default_selectivity_clause [, default_cost_clause ]
}
}
using_statistics_type::=
USING { [ schema. ] statistics_type | NULL }
default_cost_clause::=
DEFAULT COST (cpu_cost, io_cost, network_cost)
default_selectivity_clause::=
DEFAULT SELECTIVITY default_selectivity
storage_table_clause::=
WITH {SYSTEM | USER} MANAGED STORAGE TABLES
example
ASSOCIATE STATISTICS WITH PACKAGES emp_mgmt DEFAULT SELECTIVITY 10;
ASSOCIATE STATISTICS WITH INDEXES salary_index DEFAULT COST (100,5,0);