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.

See Also
UpdateStatisticsWith Method (Column, Index) UpdateStatisticsWith Method (Table)

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.