|
USER_TAB_COL_STATISTICS
Columns of user's tables, views and clustersColumns ___________________________ NUM_BUCKETS The number of buckets in histogram for the column LAST_ANALYZED The date of the most recent time this column was analyzed COLUMN_NAME Column name NUM_DISTINCT The number of distinct values in the column LOW_VALUE The low value in the column HIGH_VALUE The high value in the column DENSITY The density of the column SAMPLE_SIZE The sample size used in analyzing this column GLOBAL_STATS Are the statistics calculated without merging underlying partitions? USER_STATS Were the statistics entered directly by the user? AVG_COL_LEN The average length of the column in bytes TABLE_NAME Table, view or cluster name NUM_NULLS The number of nulls in the column
Related Commands:
DBA_PART_COL_STATISTICS ALL_PART_COL_STATISTICS USER_PART_COL_STATISTICS