Database Statistics Affected Constants (SQLDMO_STAT_AFFECT_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
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 |
Updates all statistics regardless of the source. |
SQLDMOStatistic_AffectColumn |
1 |
Updates statistics derived from column data only. |
SQLDMOStatistic_AffectIndex |
0 |
Default. Updates statistics derived from indexes only. |