Index.EnumStatistics Método
Enumerates a list of statistical information for the index.
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
Public Function EnumStatistics As DataSet
'Uso
Dim instance As Index
Dim returnValue As DataSet
returnValue = instance.EnumStatistics()
public DataSet EnumStatistics()
public:
DataSet^ EnumStatistics()
member EnumStatistics : unit -> DataSet
public function EnumStatistics() : DataSet
Valor devuelto
Tipo: System.Data.DataSet
A DataSet system object value that contains an enumerated list of statistical information. The DataSet contains a set of DataTable objects, which contain the following columns:
Column |
Data type |
Description |
|---|---|---|
RANGE_ROWS |
The estimated number of rows from the table that fall within a histogram step, excluding the upper bound. |
|
EQ_ROWS |
The estimated number of rows from the table that are equal in value to the upper bound of the histogram step. |
|
DISTICT_RANGE_ROWS |
The estimated number of distinct values within a histogram step, excluding the upper bound. |
|
RANGE_HI_KEY |
The upper bound value of a histogram step. |
Comentarios
[!NOTA]
Indexes based 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
Espacio de nombres Microsoft.SqlServer.Management.Smo