TableViewBase.UpdateStatistics 메서드 (StatisticsTarget, StatisticsScanType, Int32)

아티클
04/26/2013

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

네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

구문

‘선언
Public Sub UpdateStatistics ( _
    affectType As StatisticsTarget, _
    scanType As StatisticsScanType, _
    sampleValue As Integer _
)
‘사용 방법
Dim instance As TableViewBase 
Dim affectType As StatisticsTarget 
Dim scanType As StatisticsScanType 
Dim sampleValue As Integer

instance.UpdateStatistics(affectType, _
    scanType, sampleValue)

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

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

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

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

매개 변수

affectType
유형: Microsoft.SqlServer.Management.Smo.StatisticsTarget
A StatisticsTarget object value that specifies the target of the statistics update, such as columns or indexes.