15.10 - RemoveExcludedObject - Teradata Database

Teradata Database Application Programming Reference

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

Reinstates a previously excluded object.

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

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.

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.

 

Parameter.

Description

NumRemoved

Number of objects removed from the exclusion list.

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.