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)