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 Sub UpdateStatistics (
	scanType As StatisticsScanType,
	sampleValue As Integer,
	recompute As Boolean
)

Parameters

scanType
Type: Microsoft.SqlServer.Management.Smo.StatisticsScanType

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

sampleValue
Type: System.Int32

An Int32 value that specifies the sample value.

recompute
Type: System.Boolean

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

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

System_CAPS_noteNote

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

Return to top
Show: