UpdateStatThresholdSetting Syntax - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

API Definition

REPLACE PROCEDURE tdstats.UpdateStatThresholdSettingJSON
  (IN jIn JSON(3000) CHARACTER SET UNICODE,
   OUT jOut JSON(3000) CHARACTER SET UNICODE)

JSON Keys

JSON Key IN/OUT Data Type Description
SCOID IN BIGINT AutoStats assigned identifier of an individual statistic whose settings are to be changed.
DatabaseName IN VARCHAR(128) Apply the new settings to all statistics collected within the specified database.
TableName IN VARCHAR(128) Apply the new settings to an individual table residing within the specified DatabaseName.
ThresholdType IN CHAR(1) Type to use for THRESHOLD option for generated COLLECT STATISTICS statements.
Valid values are:
  • 'S' - Designates SYSTEM THRESHOLD
  • 'U’- Designates THRESHOLD <AgeThreshold> DAYS AND THRESHOLD <GrowthThreshold> PERCENT
  • 'N' - Designates NO THRESHOLD
AgeThreshold IN INTEGER Value for <AgeThreshold> in number of days.

Allowable values are 1 to 9999.
GrowthThreshold IN INTEGER Value for <GrowthThreshold> as a percentage.
ForCurrentOnly IN BOOLEAN
  • true - The THRESHOLD setting will be issued along with the FOR CURRENT option making it applicable to the current collection only.
  • false or NULL - The THRESHOLD setting is applied to all future collections.
NumUpdated OUT INTEGER Number of statistics whose histogram settings have been updated.