15.10 - AddExcludedObject - Teradata Database

Teradata Database Application Programming Reference

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

Specifies one or more objects whose statistics are to be permanently excluded from the Automate, Analyzer, and Collect-related operations.

REPLACE PROCEDURE TDSTATS.AddExcludedObject
 (IN DatabaseName VARCHAR(128) CHARACTER SET UNICODE,
  IN TableName    VARCHAR(128) CHARACTER SET UNICODE,
  OUT NumAdded    INTEGER)
           .
           .
           .
;
 

Parameter

Description

DatabaseName

Name of the database. DatabaseName identifies the excluded database or the database containing the excluded table.

TableName

Name of the table within the specified DatabaseName. TableName identifies the table to exclude within DatabaseName.

When you exclude objects by AddExcludedObject, it supersedes any argument values specified in calls to Automate, Analyze, and Collect-related APIs and allows Automate, Analyze, and Collect-related APIs to be called in an "everything but" manner.

Exclusion is not applicable to the TruncateAnalyzerHistory, TruncateAutomateHistory, and TruncateCollectHistory external stored procedures. Rows corresponding to any excluded objects are still deleted as part of the truncation operation assuming they qualify based on the scope of the specified input parameters. For more information about these external stored procedures, see “DBAControl Open APIs for Managing Space” on page 595.

Excluding Statistics

 

To exclude all ...

You must specify a value for ...

statistics for a particular table

DatabaseName and TableName.

objects and their statistics within a particular database

DatabaseName only.

 

Parameter

Description

NumAdded

Number of objects excluded.

The following example shows how to exclude the table named Project and automate all statistics from the Personnel database, except those on the Project table.

CALL TDSTATS.AddExcludedObject('Personnel','Project', NumAdded);
 
*** Procedure has been executed. 
 *** Total elapsed time was 1 second.
 
 NumAdded
---------
        1
 
CALL TDSTATS.AutomateStats ('Personnel', NULL, NULL, NULL,'Y','N', AutomateId, NumCopied, NumRemoved);
 
*** Procedure has been executed. 
 *** Total elapsed time was 1 second.
 
 AutomateId    NumCopied   NumRemoved
-----------  -----------  -----------
          1            4            0