Index.UpdateStatistics-Methode (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

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

instance.UpdateStatistics(scanType, sampleValue)

public void UpdateStatistics(
    StatisticsScanType scanType,
    int sampleValue
)

public:
void UpdateStatistics(
    StatisticsScanType scanType, 
    int sampleValue
)

member UpdateStatistics : 
        scanType:StatisticsScanType * 
        sampleValue:int -> unit

public function UpdateStatistics(
    scanType : StatisticsScanType, 
    sampleValue : int
)

Parameter

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

• sampleValue
  Typ: System.Int32
  An Int32 value that specifies the sample size.

Hinweise

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

Beispiele

Erstellen, Ändern und Löschen von Indizes

Siehe auch

Verweis

Index Klasse

UpdateStatistics-Überladung

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

Indizes

UPDATE STATISTICS (Transact-SQL)