15.10 - API Categories - Teradata Database

Teradata Database Application Programming Reference

Teradata Database
Programming Reference

Automate Statistic Management open APIs are divided into the following categories:





These open APIs copy the qualifying statistics definitions from the DBC dictionary to the TDSTATS database and synchronize any subsequent changes from SQL Data Definition Language operations.

For more information, see “Automating Statistics Collection and Monitoring” on page 467.


These open APIs analyze user objects and logged query plans to identify missing, stale, and unused statistics.

For more information, see “Analyzing User Objects and Logged Query Plans” on page 469.


These open APIs:

  • Batch and prioritize a list of SQL COLLECT STATISTICS statements.
  • Submit the queued list of SQL COLLECT STATISTICS statements prepared by the PrepCollect open API.
  • For more information, see “Preparing and Collecting Statistics” on page 472.


    These open APIs:

  • Control the application of recommended actions by Analyzer open APIs.
  • Override any of the default settings stored in the TDSTATS database.
  • For more information, see “Controlling Recommended Actions and Overriding Default Settings” on page 473.

    Each category of open API records its results within the TDSTATS database which can be queried using SQL.

    Specifying the Scope of API Operations

    All of the above listed categories of APIs accept input parameters that optionally limit the scope of the operation to a specified database, table, or statistic. You can also define a named list consisting of any set of databases or tables, and then call the APIs with the list name, see “Creating Object Lists” on page 481 or “Open APIs for Object Lists” on page 602.