DropStatRecs 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
- To limit the recommendations to a particular set of databases or tables, callers can specify a values for DatabaseName, TableName, or ObjectListName. Otherwise, the best set of recommendations for all AUTODBA designated tables in the system are returned.
- Recommendations are returned in ranked order according to their estimated cost savings for the system.
- Supporting evidence for each recommendation can be found in output columns LastOptimizerUsage and RecollectionElapsedTime. Higher ranked recommendations are generally those statistics that have not been used by the Optimizer for the past 30 days and are the most costly to recollect (refresh) over time.
- The Description output column contains a textual EXPLAIN-like description of all of the combined supporting evidence.