| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03  | 
  | 
  | 
View PDF | 
ALL_ASSOCIATIONS describes user-defined statistics associated with objects accessible to the current user.
Related Views
DBA_ASSOCIATIONS describes all user-defined statistics in the database.
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 | |
INTERFACE_VERSION | 
NUMBER | 
Identifies the version number of the ODCIStats interface. Value is 1 for statistics type implementing Oracle8i 8.1; 0 for types implementing Oracle9i 9.0.0. |