MissingStatRecs Example - Teradata VantageCloud Lake

This example reports any recommendations for collecting new stats on database ‘V6_ADW’.

BTEQ -- Enter your SQL request or BTEQ command:
.set sidetitles on
.set foldline on

CALL TDStats.MissingStatRecs('{"DatabaseName":"V6_ADW"}');

Result:

Rank                                                    1
SCOID                                    11700117
DatabaseName                       V6_ADW
TableName                              ordertbl_ppi
FieldNames                             "O_ORDERKEY","O_TOTALPRICE","O_ORDERDATE"
StatType                                  L
Status Approved;                    Awaiting Collection
MostRecentTimeStamp          2019-04-01 12:59:50.930000+00:00
TotalQueries                                      18
CardinalityEstimateErrors                   5
MissedSLGFrequency                        3
AvgOptimizerImportance      2.00000000000000E 000
PlanCostMagnitude                            3
RecDDLText                         COLLECT STATISTICS COLUMN("O_ORDERKEY","O_TOTALPRICE","O_ORDERDATE") ON V6_ADW.ordertbl_ppi;
QueryList                              307190584648047536,307190584648047537,307190584648047172,307190584648047537, ....
Description                           Missing stat rec on set of columns that may benefit 18 queries with 5 cardinality estimation errors and 3 missed SLGs 
                                               with an average Optimizer assigned importance of 2-High
.
.
.