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
)

Parameters

scanType
Type: Microsoft.SqlServer.Management.Smo.StatisticsScanType
A StatisticsScanType that specifies the method used to update the statistics.
sampleValue
Type: Int32
An Int32 value that specifies the sample value.
recompute
Type: Boolean
A Boolean value that specifies whether to recomputed the index statistics or not.If True, the statistics are recomputed. Otherwise, False.

NoteNote

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

ADD
Show:
© 2014 Microsoft