Table containing information about statistics that need recurring updates. |
schema_identifier | sysname (256) | NOT NULL | The schema for the statistic. |
statistic_name | sysname (256) | NOT NULL | The name of the statistic to update. For statistics that were originally auto-generated, this is the standarized name created by the "Replace_With_Update" sproc |
last_update_threshold_ss | int (4) | NOT NULL | The interval to use in deciding if a statistic needs to be updated again. |
is_disabled | bit (1) | NOT NULL | True if the statistics update should be disabled. |
type_of_scan | tinyint (1) | NOT NULL | The type of scan to use, whether it is DEFAULT(0), FULL(1) or PERCENT(2). |
scan_percent | tinyint (1) | | If PERCENT is specified as the type, this is the percent to use. |
object_entity_name | sysname (256) | NOT NULL | The entity the statistic is part of. |