GetIndexStatHistoryHandle( ) method

Returns the handle of the temp-table used for storing the archived statistics from the _IndexStat virtual system table. The property returns the Unknown value (?) if the ArchiveIndexStatistics property is never set to TRUE.

Return type:

HANDLE

Access:

PUBLIC STATIC

Applies to:

Progress.Database.TempTableInfo class

The temp-table that the method returns is a dynamic temp-table called _IndexStatHistory. This is maintained by the AVM and cannot be deleted when the ArchiveIndexStatistics property is set to TRUE. If you try to delete it, the AVM raises an error. The _IndexStatHistory dynamic temp-table can be deleted if the ArchiveIndexStatistics property is set to FALSE.

The records in this table can be manipulated by emptying the temp-table. If the ArchiveIndexStatistics property is again set to TRUE, then the dynamic temp-table _IndexStatHistory is recreated. It contains all the fields from _IndexStat, except the _IndexStat-id field.

The fields that will be present in the _IndexStat table are listed below:

__Index-name

A character field with the index name in the format table-name.index-name.

__Proc-name

A character field with the name of the procedure where the temp-table was created.

_Delete-Timestamp

The date-time field with the timestamp denoting when the temp-table index got deleted.

 

Syntax 

GetIndexStatHistoryHandle()