DropStatRecs Syntax - Teradata Vantage

API Definition

REPLACE PROCEDURE TDStats.DropStatRecs(
  IN jIn JSON(2000) CHARACTER SET UNICODE)
  DYNAMIC RESULT SETS 1

JSON Key	Data Type	Description
DatabaseName	VARCHAR(128)	Limit recommendations to those on the specified database.
ObjectName	VARCHAR(128)	Further limit recommendations to those on specified table of DatabaseName.
ObjectListName	VARCHAR(128)	Limit recommendations to named list of objects. See related API "CreateObjectList" in ObjectList APIs Syntax.
MaxRank	INTEGER	Limit returned recommendations to those with a ranking <= specified value.

Column Name	Data Type	Description
Rank	INTEGER	Ranking of recommendation relative to others where the best recommendation has a ranking of 1.
SCOID	BIGINT	AutoStats assigned unique numeric identifier for the statistic recommendation.
DatabaseName	VARCHAR(128)	Database on which the recommendation was made.
TableName	VARCHAR(128)	Table on which the recommendation was made.
FieldNames	VARCHAR(10000)	Comma separated list of field names on which the recommendation was made.
StatType	CHAR(1)	'F' - Single field 'L' - List of fields 'I' - Indexed fields 'S' - Table summary only.
Status	VARCHAR(128)	Status indicating if the recommendation is awaiting approval or already approved but still awaiting application.
MostRecentTimeStamp	TIMESTAMP(6)	Timestamp of when the recommendation was most recently made.
LastOptimizerUsage	TIMESTAMP(6)	Timestamp of when the statistic was last used by the Query Optimizer.
RecollectionElapsedTime	INTERVAL HOUR(4) TO SECOND	Average elapsed time to recollect the statistic.
RecDDLText	VARCHAR(10000)	SQL DDL text associated with the recommendation.
Description	VARCHAR(256)	EXPLAIN-like text description of supporting evidence.