Méthode EnumStatistics
Enumerates a list of statistical information for the index.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
Public Function EnumStatistics As DataSet
'Utilisation
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
Valeur de retour
Type : 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. |
Notes
Notes
Indexes based on the UserDefinedTableType object do not support statistics and running this method will generate an exception.
Voir aussi