2.47 ALL_ASSOCIATIONS
ALL_ASSOCIATIONS describes user-defined statistics associated with objects accessible to the current user.
Related Views
-
DBA_ASSOCIATIONSdescribes all user-defined statistics in the database. -
USER_ASSOCIATIONSdescribes user-defined statistics associated with objects owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the object for which the association is being defined |
|
|
|
|
Name of the object for which the association is being defined |
|
|
|
|
Column name in the object for which the association is being defined |
|
|
|
|
Kind of object with which statistics are being associated: column, type, package or function, indextype, or domain index. |
|
|
|
|
Owner of the statistics type |
|
|
|
|
Name of statistics type that contains the cost, selectivity or statistics functions |
|
|
|
|
Default selectivity of the object, if any |
|
|
|
|
Default CPU cost of the object, if any |
|
|
|
|
Default I/O cost of the object, if any |
|
|
|
|
Default networking cost of the object, if any |
|
|
|
|
Identifies the version number of the |
|
|
|
|
Specifies whether the object is system-managed or user-managed |
See Also: