You can use the ActivateStat external stored procedure to mark a still active or inactive statistic as permanently active so that the statistic is removed from future consideration by CleanupStats. See CleanupStats.
Reactivating Statistics
If you do not specify a value for the following input parameters, the operation is performed on all user created databases in the system.
What to Reactivate | Values to Specify |
---|---|
Single statistic | SCOID When specifying a value for SCOID, you need not specify a value for the DatabaseName or TableName.
|
All statistics for a database | DatabaseName |
All statistics for a table | DatabaseName and TableName |
List of objects that cannot be specified by DatabaseName or TableName | ObjectListName that was previously created by the CreateObjectList and AddObjectListEntry external stored procedures. ObjectListName usage is mutually exclusive with DatabaseName and TableName . When you specify a value other than NULL for ObjectListName , DatabaseName and TableName must be NULL. |