Table: dbo.Scheduled_Statistics_Update
Table containing information about statistics that need recurring updates.
Columns
NameTypeConstraintsDescription
schema_identifiersysname (256)NOT NULLThe schema for the statistic.
statistic_namesysname (256)NOT NULLThe 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_ssint (4)NOT NULLThe interval to use in deciding if a statistic needs to be updated again.
is_disabledbit (1)NOT NULLTrue if the statistics update should be disabled.
type_of_scantinyint (1)NOT NULLThe type of scan to use, whether it is DEFAULT(0), FULL(1) or PERCENT(2).
scan_percenttinyint (1)If PERCENT is specified as the type, this is the percent to use.
object_entity_namesysname (256)NOT NULLThe entity the statistic is part of.
Primary key
NameColumnsDescription
PK_Scheduled_Statistics_Update$schema_identifier$object_entity_name$statistic_nameschema_identifier, statistic_name, object_entity_name

Schema diagram