Index.UpdateStatistics Method (StatisticsScanType)

Updates statistics for the referenced index with the specified statistics scan type.

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

Syntax

'Declaration
Public Sub UpdateStatistics ( _
    scanType As StatisticsScanType _
)
'Usage
Dim instance As Index 
Dim scanType As StatisticsScanType

instance.UpdateStatistics(scanType)

public void UpdateStatistics(
    StatisticsScanType scanType
)

public:
void UpdateStatistics(
    StatisticsScanType scanType
)

member UpdateStatistics : 
        scanType:StatisticsScanType -> unit

public function UpdateStatistics(
    scanType : StatisticsScanType
)

Parameters

• scanType
  Type: Microsoft.SqlServer.Management.Smo.StatisticsScanType
  A StatisticsScanType the method used to update the statistics.

Remarks

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)