本站中文解释
Oracle视图DBA_TAB_COL_STAT_MODELS用于显示和汇总某个表的所有列的统计信息。它可以用来查询每个列上保留的字节数、非空值的总数、最大值、最小值、平均值等等。
使用Oracle视图DBA_TAB_COL_STAT_MODELS非常简单，只要给出表名即可：
SELECT * FROM DBA_TAB_COL_STAT_MODELS WHERE TABLE_NAME = ‘表名’;
如果只想知道具体某一列的统计信息，可以使用AND子句，并包括该列的名字：
SELECT * FROM DBA_TAB_COL_STAT_MODELS WHERE TABLE_NAME = ‘表名’ AND COLUMN_NAME = ‘列名’;
官方英文解释
DBA_TAB_COL_STAT_MODELS describes real-time statistics models for all tables in the database. Its columns are the same as those in ALL_TAB_COL_STAT_MODELS.
Real-time statistics models use machine learning algorithms to predict the number of distinct values (NDV) for table columns.
Note:
This view is available starting with Oracle Database 21c.
See Also:
“ALL_TAB_COL_STAT_MODELS”
