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.

Comentarios

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

Sobrecarga de UpdateStatistics

Espacio de nombres Microsoft.SqlServer.Management.Smo

Otros recursos

Índices

UPDATE STATISTICS (Transact-SQL)