Udostępnij przez


Index.UpdateStatistics Method (StatisticsScanType, Int32)

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

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

Syntax

'Deklaracja
Public Sub UpdateStatistics ( _
    scanType As StatisticsScanType, _
    sampleValue As Integer _
)
public void UpdateStatistics (
    StatisticsScanType scanType,
    int sampleValue
)
public:
void UpdateStatistics (
    StatisticsScanType scanType, 
    int sampleValue
)
public void UpdateStatistics (
    StatisticsScanType scanType, 
    int sampleValue
)
public function UpdateStatistics (
    scanType : StatisticsScanType, 
    sampleValue : int
)

Parameters

  • sampleValue
    An Int32 value that specifies the sample size.

Remarks

Uwaga

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

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.