Index.UpdateStatistics 方法 (StatisticsScanType, Int32)

Updates statistics for the referenced index with the specified statistics scan type and specified sample size.

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
Public Sub UpdateStatistics ( _
    scanType As StatisticsScanType, _
    sampleValue As Integer _
)
'用途
Dim instance As Index 
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
)

參數

• scanType
  型別：Microsoft.SqlServer.Management.Smo.StatisticsScanType
  A StatisticsScanType the method used to update the statistics.

• sampleValue
  型別：System.Int32
  An Int32 value that specifies the sample size.

備註

[!附註]

Indexes based partly on the UserDefinedTableType object do not support statistics and running this method will generate an exception.

範例

建立、改變和移除索引

請參閱

參考

Index 類別

UpdateStatistics 多載

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

索引

UPDATE STATISTICS (Transact-SQL)