This example lists all the automated statistics that are currently defined within database SemiDb.
bteq> .set sidetitles on
bteq> .set foldline on
bteq> call TDStats.SelectAutomatedStatsJSON('{"DatabaseName":"SemiDB"}',jout);
Result:
jOut {}
*** ResultSet# 1 : 17 rows returned by "TDSTATS.SELECTAUTOMATEDSTATSJSON".
DatabaseName semiDb
TableName CUSTOMER
ExpressionList SUBSTRING((TD_SYSFNLIB.LTRIM ( C_PHONE )) FROM (1 ) FOR (2 ))
IndexNumber ?
IndexName ?
StatsId 1
StatsName SUBSTRING((TD_SYSFNL_390
SCOID 390
ApprovedStat Y
Excluded N
StatsState C
StatsOrigin A
StatsType T
LastCollectTimeStamp 2024-05-28 13:07:44
LastEvaluationTimeStamp 2024-05-28 13:07:44.170000+00:00
SubmissionSkipCnt 0
ThresholdSkipCnt 0
UserImportance 5
SystemImportance 2
ActiveStat Y
LastAccessedByOpt ?
QryUsageFrequency 0
MissingFrequency 0
EstPercentDataChange 0
Age 0
ThresholdSignature Global Default
EstimateError N
EstErrFrequency 0
CreateUser TDAAS_AUTODB1
CreateTimeStamp 2024-05-28 13:06:24.740000+00:00
LastAlterUser TDAAS_AUTODB1
LastAlterTimeStamp 2024-05-28 13:07:44.170000+00:00
.
.
.