RemoveExcludedObject Stored Procedure | Teradata Vantage - 17.10 - RemoveExcludedObject - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

Reinstates a previously excluded object.

Syntax

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

Syntax Elements

DatabaseName
Name of the database. DatabaseName allows you to specify the database to reinstate or the database containing a table to reinstate.
TableName
Name of the table within the specified DatabaseName. TableName allows you to specify a table within DatabaseName to be reinstated.
NumRemoved
Number of objects removed from the exclusion list.

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.

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.