3.135 ALL_USTATS
ALL_USTATS
describes the user-defined statistics collected on the tables and indexes accessible to the current user.
Related Views
-
DBA_USTATS
describes the user-defined statistics collected on all tables and indexes in the database. -
USER_USTATS
describes the user-defined statistics collected on the tables and indexes owned by the current user.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the table or index for which the statistics have been collected |
|
|
|
Name of the table or index for which the statistics have been collected |
|
|
|
Partition name of a table; NULL if the table is either nonpartitioned or the entry corresponds to the aggregate statistics for the table |
|
|
|
Type of the object for which statistics have been collected:
|
|
|
|
Statistics type association:
|
|
|
|
Column name, if |
|
|
|
Schema of the statistics type which was used to collect the statistics |
|
|
|
Name of the statistics type which was used to collect statistics |
|
|
|
User-collected statistics for the object |
See Also: