Histogram Related Settings APIs Usage Notes - 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
- 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).