DropStatRecs Example - Teradata Vantage

This example reports any recommendations to drop statistics that currently exist on database ‘V6_ADW’.

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

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

Result:

Rank                                                    1
SCOID                                       1100007
DatabaseName                        V6_ADW
TableName                               Dept
FieldNames                              D_Desc
StatType                                   F
Status                                      Pending Recommendation
MostRecentTimeStamp           2019-01-17 11:33:28.980000+00:00
LastOptimizerUsage                2018-10-31 00:00:00.00
ReCollectionElapsedTime       0:00:01.230000
RecDDLText                           DROP STATISTICS COLUMN("D_Desc") ON V6_ADW.Dept;
Description                            Drop stat rec on column that was last used by the Optimizer on 2018-10-31 and whose estimated recollection time is 83 seconds.
.
.
.