Index.UpdateStatistics Method

Updates statistics for the referenced index.

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

Syntax

'Declaration
Public Sub UpdateStatistics
'Usage
Dim instance As Index

instance.UpdateStatistics()

public void UpdateStatistics()

public:
void UpdateStatistics()

member UpdateStatistics : unit -> unit

public function UpdateStatistics()

Remarks

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

Note

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

Examples

Creating, Altering, and Removing Indexes

See Also

Reference

Index Class

UpdateStatistics Overload

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Indexes

UPDATE STATISTICS (Transact-SQL)