15.10 - Orphaned Statistics - Teradata Database

Teradata Database Application Programming Reference

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

If you issue an SQL DROP STATISTICS, DROP TABLE, or DROP DATABASE statement on a statistic that was previously automated, the resulting entry in the TDSTATS database is orphaned (that is, the PrepCollect API will not prepare a collection on that particular statistic again). For more information about this open API, see “PrepCollect” on page 546.

To remove an orphaned statistic from the TDSTATS database, you can call the ResyncStats open API. For more information about this open API, see “ResyncStats” on page 509.