UpdateStatistics Método (StatisticsScanType, Int32)

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

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
Public Sub UpdateStatistics ( _
    scanType As StatisticsScanType, _
    sampleValue As Integer _
)
'Uso
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
)

Parámetros

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

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

Notas

[!NOTA]

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

Ejemplos

Crear, modificar y eliminar índices

Vea también

Referencia

Index Clase

Index Miembros

UpdateStatistics Sobrecarga

Microsoft.SqlServer.Management.Smo Espacio de nombres

Otros recursos

Índices

UPDATE STATISTICS (Transact-SQL)