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: Int32
An Int32 value that specifies the sample value.
Type: 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft