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. |
UpdateStatisticsWith Method (Table)