TableViewBase.UpdateStatistics Method (StatisticsTarget, StatisticsScanType, Int32)

 

Updates the statistics for the table or view with the option to specify the target, the type of scan performed, and the sample size.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public void UpdateStatistics(
	StatisticsTarget affectType,
	StatisticsScanType scanType,
	int sampleValue
)

Parameters

affectType
Type: Microsoft.SqlServer.Management.Smo.StatisticsTarget

A StatisticsTarget object value that specifies the target of the statistics update, such as columns or indexes.

scanType
Type: Microsoft.SqlServer.Management.Smo.StatisticsScanType

A StatisticsScanType object value that specifies the way in which statistical information is gathered.

sampleValue
Type: System.Int32

An Int32 value that specifies the sample size. The units are dependent on the scan type.

Return to top
Show: