SHOW META

Description

Views metadata of CBO statistics, including basic statistics and histograms.

This statement is supported from v2.4.

View metadata of basic statistics

Syntax

SHOW STATS META [WHERE]

This statement returns the following columns.

Column	Description
Database	The database name.
Table	The table name.
Columns	The column names.
Type	The type of statistics. FULL means full collection and SAMPLE means sampled collection.
UpdateTime	The latest statistics update time for the current table.
Properties	Custom parameters.
Healthy	The health of statistical information.

View metadata of histograms

Syntax

SHOW HISTOGRAM META [WHERE];

This statement returns the following columns.

Column	Description
Database	The database name.
Table	The table name.
Column	The columns.
Type	Type of statistics. The value is HISTOGRAM for histograms.
UpdateTime	The latest statistics update time for the current table.
Properties	Custom parameters.

References

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