15.10 - FROM Clause - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)
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;