Edit

SHOW META

Description

Views metadata of statistics, including basic statistics and histograms.

View metadata of basic statistics

Syntax

SHOW STATS META [WHERE];

This statement returns the following columns.

ColumnDescription
DatabaseThe database name.
TableThe table name.
ColumnsThe column names.
TypeThe type of statistics. FULL means full collection and SAMPLE means sampled collection.
UpdateTimeThe latest statistics update time for the current table.
PropertiesCustom parameters.
HealthyThe health of statistical information.

View metadata of histograms

Syntax

SHOW HISTOGRAM META [WHERE];

This statement returns the following columns.

ColumnDescription
DatabaseThe database name.
TableThe table name.
ColumnThe columns.
TypeType of statistics. The value is HISTOGRAM for histograms.
UpdateTimeThe latest statistics update time for the current table.
PropertiesCustom parameters.

References

For more information about collecting statistics for CBO, see Gather statistics for CBO.