15.10 - Automated Statistics Management API - Teradata Database

Teradata Database Application Programming Reference

Teradata Database
Programming Reference

Automated Statistics Management API consist of interfaces to open APIs. You can use these open APIs to:

  • Identify situation where statistics management might be improved (for example, missing, out of date (also referred to as stale), and unused statistics).
  • Ability to control the application of recommended actions by the Analyzer operation and override any of the default settings stored in TDSTATS database.
  • View and modify the prepared collection list prepared by the Automated Statistics Management PrepCollect open API prior to its actual submission.
  • Note: Teradata recommends that you interface with these APIs directly through Teradata Viewpoint Stats Manager portlet. If you require a specific, customized API that the Teradata Viewpoint Stats Manager portlet does not provide, you can call the Automated Statistics Management APIs directly from your own application.