Show TOC

Object documentationDATASOURCETABLESTATISTICS

 

The system table SYSINFO.DATASOURCETABLESTATISTICS displays information about table statistics.

This information is only relevant for SAP MaxDB bridge functionality.

Structure

DATASOURCETABLESTATISTICS

DATASOURCENAME

CHAR(32)

Name of the data source

SCHEMANAME

CHAR(32)

Name of the schema

TABLENAME

CHAR(32)

Name of the table

DISTRIBUTIONKEYNAME

CHAR(32)

Name of the distribution key in the data source

EXECUTEDATE

TIMESTAMP

Time stamp of Update Statistics run

ROWCOUNT

FIXED(20)

Number of rows determined during Update Statistics

DISTINCTVALUECOUNT

FIXED(20)

Number of distinct values determined during Update Statistics

More Information

Data Source Name