Table: dbo.Scheduled_Statistics_Update
Table containing information about statistics that need recurring updates.
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Scheduled_Statistics_Update$schema_identifier$object_entity_name$statistic_name | schema_identifier, statistic_name, object_entity_name |