Condividi tramite


EnumLastStatisticsUpdates Method

Questa caratteristica verrà rimossa a partire da una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa caratteristica in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.

The EnumLastStatisticsUpdates method returns a QueryResults object that enumerates the query optimizing statistics maintained on a table.

Sintassi

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.

Osservazioni

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.

Applies To: