Column.UpdateStatistics Method (StatisticsScanType, Int32)

Updates Statistic objects that monitor this column using a sampled scan.

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

Syntax

'Declaration
Public Sub UpdateStatistics ( _
    scanType As StatisticsScanType, _
    sampleValue As Integer _
)
'Usage
Dim instance As Column 
Dim scanType As StatisticsScanType 
Dim sampleValue As Integer

instance.UpdateStatistics(scanType, sampleValue)

public void UpdateStatistics(
    StatisticsScanType scanType,
    int sampleValue
)

public:
void UpdateStatistics(
    StatisticsScanType scanType, 
    int sampleValue
)

member UpdateStatistics : 
        scanType:StatisticsScanType * 
        sampleValue:int -> unit

public function UpdateStatistics(
    scanType : StatisticsScanType, 
    sampleValue : int
)

Parameters

• scanType
  Type: Microsoft.SqlServer.Management.Smo.StatisticsScanType
  A StatisticsScanType object value that specifies the type operation to perform during the creation or update of a Statistic object.

• sampleValue
  Type: System.Int32
  An Int32 value that specifies the number of rows or percentage of the total number of rows to use in a sampled scan. This parameter is required only when the scanType indicates a sampled scan.

Remarks

Examples

Working with Database Objects

See Also

Reference

Column Class

UpdateStatistics Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

UPDATE STATISTICS (Transact-SQL)

Statistics