DoNotPreserveAfterRecreate Syntax - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
REPLACE PROCEDURE TDSTATS.DoNotPreserveAfterRecreate (
  IN DatabaseName VARCHAR(128) CHARACTER SET UNICODE,
  IN ObjectName VARCHAR(128) CHARACTER SET UNICODE,
  IN ObjectListName VARCHAR(128) CHARACTER SET UNICODE,
  OUT NumNotPreserved INTEGER
)
  ...
;

Syntax Elements

DatabaseName
Database whose automated statistics are no longer to be marked for preservation.
ObjectName
Table within DatabaseName whose statistics are no longer to be marked for preservation.
ObjectListName
Object list whose defined databases and tables are no longer to be marked for preservation.
NumNotPreserved
Number of statistics marked no longer eligible for preservation.