EnumLastStatisticsUpdates Method
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The EnumLastStatisticsUpdates method returns a QueryResults object that enumerates the query optimizing statistics maintained on a table.
Syntax
object
.EnumLastStatisticsUpdates( [ IndexName ] )
as QueryResults
Parts
- object
Expression that evaluates to an object in the Applies To list.
- IndexName
Optional. String that names an existing index and that restricts output to the index named.
Prototype (C/C++)
HRESULT EnumLastStatisticsUpdates(
LPSQLDMOQUERYRESULTS* ppResults,
SQLDMO_LPCSTR IndexName = NULL);
Returns
A QueryResults object that contains one result set defined by these columns.
| Column | Data type | Description |
|---|---|---|
last update |
smalldatetime |
Date and time of most recent update. When NULL, the distribution statistics have not been updated after object creation. |
name |
nvarchar(129) |
Index name or statistics definition name. |
Remarks
Data distribution statistics are maintained for indexes defined on a table and as directed by the user. By default, the EnumLastStatisticsUpdates method returns a result set that contains rows referencing both indexes and system and user-defined data distribution statistics.