SYSCOLUMNSTATISTICS System View

The SYSCOLUMNSTATISTICS table view describes the statistics for a specific table column within the current database.

SYS.SYSCOLUMNSTATISTICS is a system view.

The following table shows the contents of the SYSCOLUMNSTATISTICS system view.

SYSCOLUMNSTATISTICS system view
Column Name Type Length Nullable Contents
SCHEMANAME VARCHAR 32672 YES The name of the schema.
TABLENAME VARCHAR 32672 YES The name of the table.
COLUMNNAME VARCHAR 32672 YES The name of the column.
CARDINALITY BIGINT 19 YES The estimated number of distinct values for the column.
NULL_COUNT BIGINT 19 YES The number of rows in the table that have NULL for the column.
NULL_FRACTION REAL 23 YES

The ratio of NULL records to all records:

NULL_COUNT / TOTAL_ROW_COUNT
MIN_VALUE VARCHAR 32672 YES The minimum value for the column.
MAX_VALUE VARCHAR 32672 YES The maximum value for the column.
QUANTILES VARCHAR 32672 YES

The quantiles statistics sketch for the column.

FREQUENCIES VARCHAR 32672 YES The frequencies statistics sketch for the column.
THETA VARCHAR 32672 YES The theta statistics sketch for the column.

The QUANTILES, FREQUENCIES, and THETA values are all sketches computed using the Yahoo Data Sketches library, which you can read about here: https://datasketches.github.io/

See Also