DailyTuningActivity Syntax - 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

API Definition

REPLACE PROCEDURE TDStats.DailyTuningActivity(
    IN jIn JSON(2000) CHARACTER SET UNICODE)
    DYNAMIC RESULT SETS 1

JSON Input Keys

JSON Key Data Type Description
BeginDate DATE Starting date for tuning activity.
EndDate DATE Ending date for tuning activity.
ReturnTable BOOLEAN When true, results will be stored in a session level temporary table named AutoDBA_DailyTuningActivity rather than being returned as a dynamic result.

Default is false.

Dynamic SQL Result Columns

Column Name Data Type Description
ReportDate DATE Date reported for tuning action.
DatabaseName CHAR(128) Database on which tuning action was made.
IdentifiedMissingStats INTEGER Number of missing (new) statistics recommended.
IdentifiedStaleStats INTEGER Number of stale statistics in need of refresh.
IdentifiedUnusedStats INTEGER Number of unused stats that can be dropped.
LoadEventsDetected INTEGER Number of table bulk load operations detected.
MissingStatsApplied INTEGER Number of missing (new) stats applied as part of the initial (first time) collection.
StatsSubmitted INTEGER Number of statistics submitted for [re]collection including both initial and refresh.
StatsCollected INTEGER Number of submitted statistics that were collected and not skipped.
ThresholdSkipped INTEGER Number of submitted statistics that were skipped due to the change-based threshold not being met.
StatsDropped INTEGER Number of unused statistics that were dropped.
CollectStatErrors INTEGER Number of errors from Collect Stats
DropStatErrors INTEGER Number of errors from Drop Stats.