15.10 - Excluded Statistics - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

Automate-related open APIs automatically exclude statistics (such as Geospatial statistics) that do not support the SQL COLLECT STATISICS statement with THRESHOLD option.

If a statistic is excluded, you will receive a warning message from the AutomateReport open API highlighting the statistic (for details, see “AutomateReport” on page 501).

For more information about the SQL COLLECT STATISICS statement with THRESHOLD option, see SQL Data Definition Language.

 

If you want to ...

Use the following SQL interface...

copy statistics definitions for a specified database or table from the DBC dictionary to the TDSTATS database

“AutomateStats” on page 488.

copy the definition of a single specified statistic from the dictionary to the TDSTATS database

“AutomateSingleStat” on page 492.

copy the definitions of those statistics identified by a prior Analyzer-related operation as actively used but not yet automated to the TDSTATS database

“AutomateUsedStats” on page 494.

remove specified statistics definitions from the TDSTATS database

“DeAutomateStats” on page 497.

list statistics definitions copied or removed by a prior invocation of an Automate-related open API

“AutomateReport” on page 501.

list automated statistics definitions that currently reside in the TDSTATS database

“SelectAutomatedStats” on page 504.

remove orphaned statistics definitions from the TDSTATS database that are no longer defined in the dictionary

“ResyncStats” on page 509.