Index.EnumStatistics-Methode
Enumerates a list of statistical information for the index.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Function EnumStatistics As DataSet
'Usage
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
Rückgabewert
Typ: 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. |
Hinweise
.gif "Hinweis") Hinweis |
|---|
Indexes based 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
Microsoft.SqlServer.Management.Smo-Namespace