Histogram Related Settings APIs Usage Notes - 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
  • Users are cautioned to use these APIs sparingly and instead rely on system determined optimal settings as optimal settings vary by individual statistic.
  • Settings can be applied at different levels including database, table, and individual statistic by specifying one or more non-null values for parameters DatabaseName, TableName, or SCOID.
  • Use API SelectAutomatedStats to determine the SCOID value for an individual statistics.
  • In addition to objects marked semi-autonomous with the AUTODBA WITH CHECK syntax option, this API can also be used in conjunction with objects marked fully autonomous via the AUTODBA option (no WITH CHECK).