ALL_ASSOCIATIONS

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.
MAINTENANCE_TYPE VARCHAR2(14)   Specifies whether the object is system-managed or user-managed