Static Data Dictionary Views, 4 of 452

ALL_ASSOCIATIONS

ALL_ASSOCIATIONS describes user-defined statistics associated with objects accessible to the current user.

USER_ASSOCIATIONS describes user-defined statistics associated with objects owned by the current user.

Column	Datatype	NULL	Description
`OBJECT_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the object for which the association is being defined
`OBJECT_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the object for which the association is being defined
`COLUMN_NAME`	`VARCHAR2(30)`		Column name in the object for which the association is being defined
`OBJECT_TYPE`	`VARCHAR2(9)`		Kind of object with which statistics are being associated: column, type, package or function, indextype, or domain index.
`STATSTYPE_SCHEMA`	`VARCHAR2(30)`		Owner of the statistics type
`STATSTYPE_NAME`	`VARCHAR2(30)`		Name of statistics type that contains the cost, selectivity or statistics functions
`DEF_SELECTIVITY`	`NUMBER`		Default selectivity of the object, if any
`DEF_CPU_COST`	`NUMBER`		Default CPU cost of the object, if any
`DEF_IO_COST`	`NUMBER`		Default I/O cost of the object, if any
`DEF_NET_COST`	`NUMBER`		Default networking cost of the object, if any