15.10 - FROM Clause - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K
qcd_name

Statistics to be retrieved are found in the QCD. TableStatistics table of the specified QCD database or user.

FOR QUERY query_ID

Unique identifier for the set of statistics to be found in QCD.TableStatistics.QueryId.

The default value is 0.

SAMPLEID statistics_ID

Unique identifier for the given column or index in QCD.TableStatistics.StatisticsId.

USING MODIFIED

Reports the modified statistics stored in QCD.TableStatistics.ModifiedStats.

If you do not specify USING MODIFIED, Teradata Database reports the unmodified statistics stored in QCD.TableStatistics.StatisticsInfo.

Example: Reporting Detailed QCD Statistics

This example requests all of the detailed QCD statistics on the employee table in database personnel from the QCD database my_qcd.

     SHOW STATISTICS VALUES ON personnel.employee FROM my_qcd;