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

Syntax

GetIndexStatHistoryHandle()

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.