SQL-DMO
Database Statistics Scanning Constants (SQLDMO_STAT_SCAN_TYPE)
Database statistics scanning 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_FullScan | 3 | Perform a full scan of the index(es) or column(s) to determine statistics values. |
| SQLDMOStatistic_Percent | 1 | Perform a sampled scan using a percentage value. When specified, use the ScanNumber value to indicate percentage. Specify percentage using a whole number, for example, 55 specifies 55 percent. |
| SQLDMOStatistic_Rows | 2 | Perform a sampled scan using a number of rows. When specified, use the ScanNumber argument to indicate number of rows. |
| SQLDMOStatistic_Sample | 0 | Perform a percentage sampled scan using a system defined percentage. |