Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Index.UpdateStatistics Method (StatisticsScanType, Int32, Boolean)


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

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

public void UpdateStatistics(
	StatisticsScanType scanType,
	int sampleValue,
	bool recompute


Type: Microsoft.SqlServer.Management.Smo.StatisticsScanType

A StatisticsScanType that specifies the method used to update the statistics.

Type: System.Int32

An Int32 value that specifies the sample value.

Type: System.Boolean

A Boolean value that specifies whether to recomputed the index statistics or not.

If True, the statistics are recomputed. Otherwise, False.


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

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft