COLUMN_STATISTICS 表提供对列值直方图统计信息的访问。The COLUMN_STATISTICS table provides
access to histogram statistics for column values.
有关直方图统计信息,请参阅 第 10.9.6 节,“优化器统计信息”,以及 第 15.7.3.1 节,“ANALYZE TABLE 语句”。For information about histogram statistics, see Section 10.9.6, “Optimizer Statistics”, and Section 15.7.3.1, “ANALYZE TABLE Statement”.
您只能查看对您具有某些权限的列的信息。You can see information only for columns for which you have some privilege.
COLUMN_STATISTICS 表具有以下列:The COLUMN_STATISTICS table has these
columns:
SCHEMA_NAMESCHEMA_NAME统计信息适用的模式名称。The names of the schema for which the statistics apply.
TABLE_NAMETABLE_NAME统计信息适用的列的名称。The names of the column for which the statistics apply.
COLUMN_NAMECOLUMN_NAME统计信息适用的列的名称。The names of the column for which the statistics apply.
HISTOGRAMHISTOGRAM一个
JSON对象,用于描述列统计信息,以直方图的形式存储。AJSONobject describing the column statistics, stored as a histogram.