MissingStatRecs Syntax - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
wyu1683671641248.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
wyu1683671641248

API Definition

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

JSON Input Keys

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.

Dynamic SQL Result Columns

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 or join index on which 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.
TotalQueries BIGINT Total number of queries expected to benefit from the recommendation.
CardinalityEstimateErrors BIGINT Number of relevant queries that had Optimizer cardinality estimation errors.
MissedSLGFrequency BIGINT Number of relevant queries that missed their Service Level Goal (SLG).
AvgOptimizerImportance VARCHAR(10) Optimizer assigned importance of the recommendation.
PlanCostMagnitude INTEGER Average cost of relevant queries expressed as number of digits in cost.
RecDDLText VARCHAR(10000) SQL DDL text associated with the recommendation.
QueryList VARCHAR(2000) Comma separated list of DBQL QueryIds expected to benefit from statistics.
Description VARCHAR(256) EXPLAIN-like text description of supporting evidence.