15.10 - API Categories - Teradata Database

Teradata Database Application Programming Reference

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

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

 

Category

Description

Automate

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.

Analyzer

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.

Collect

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.

    DBAControl

    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.