共用方式為


Index.UpdateStatistics 方法

Updates statistics for the referenced index.

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

語法

'宣告
Public Sub UpdateStatistics
'用途
Dim instance As Index

instance.UpdateStatistics()
public void UpdateStatistics()
public:
void UpdateStatistics()
member UpdateStatistics : unit -> unit
public function UpdateStatistics()

備註

This method performs a sample scan on the target table or indexed view. The sample size is automatically computed.

[!附註]

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)