Database Statistics Affected Constants (SQLDMO_STAT_AFFECT_TYPE)

SQL-DMO

SQL-DMO

Database Statistics Affected Constants (SQLDMO_STAT_AFFECT_TYPE)

Database statistics affected constants control behavior of the UpdateStatisticsWith method of the Table object. Use the UpdateStatisticsWith method to force a refresh of query optimization supporting statistics maintained by Microsoft® SQL Server™.

Constant Value Description
SQLDMOStatistic_AffectAll 2 Update all statistics regardless of the source.
SQLDMOStatistic_AffectColumn 1 Update statistics derived from column data only.
SQLDMOStatistic_AffectIndex 0 Default. Update statistics derived from indexes only.

See Also

UpdateStatisticsWith Method (Table)