16.20 - RemoveExcludedObject - Teradata Vantage NewSQL Engine

Teradata Vantage™ Application Programming Reference

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Programming Reference
featnum
B035-1090-162K

Reinstates a previously excluded object.

Definition

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

Input Parameters

Parameter Description
DatabaseName Name of database. DatabaseName allows you to specify the database to reinstate or the database containing a table to reinstate.
TableName Name of the table. TableName allows you to specify a table within DatabaseName to be reinstated.

Usage Notes

Reinstated objects and their statistics are considered by subsequent invocations of Automate, Analyzer, and Collect-related external stored procedures.

Reinstating Statistics

To reinstate all ... You must specify a value for ...
objects and statistics within a specified database DatabaseName only.
statistics for a specified table both DatabaseName and TableName.

Output Parameter

Parameter. Description
NumRemoved Number of objects removed from the exclusion list.

Example: Using RemoveExcludedObject

The following example shows how to reinstate the Personnel.Project table and prepare all statistics for the Personnel database, including those on the Personnel.Project table.

CALL TDSTATS.RemoveExcludedObject('PERSONNEL','PROJECT', NumRemoved);
*** Procedure has been executed.
*** Total elapsed time was 1 second.
 NumRemoved
-----------
        1
CALL TDSTATS.PrepCollect ('PERSONNEL', NULL, NULL, NULL, NumStmtsPrepped, NumStatsPrepped, CmdListID);
*** Procedure has been executed.
*** Total elapsed time was 3 seconds.