EnumStatistics 方法
Enumerates a list of statistical information for the index.
命名空間: Microsoft.SqlServer.Management.Smo
組件: Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)
語法
'宣告
Public Function EnumStatistics As DataSet
'用途
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
傳回值
型別: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. |
備註
[!附註]
Indexes based on the UserDefinedTableType object do not support statistics and running this method will generate an exception.