RemoveMissingRecs Stored Procedure | VantageCloud Lake - RemoveMissingRecs - 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

This stored procedure erases a set of missing statistic recommendations from past Analyze Jobs where such recommendations have not yet been approved or applied. RemoveMissingRecs is used by callers to "clear the slate" after performing a series of trial-only tuning analysis experiments. The erasure is not equivalent to “Disapproval” in that the system is free to make the same recommendations in future analysis runs. API is applicable only to recommendations made on objects marked as semi-autonomous via the WITH CHECK option.