ArchiveIndexStatistics property

When ArchiveIndexStatistics property is set to TRUE, it creates a dynamic temp-table _IndexStatHistory that stores the index statistics for every temp-table in the session range. The temp-table to which the data is archived cannot be deleted. It contains one record for every deleted application temp-table This is a read-write property.

You cannot archive the statistics when:

ArchiveIndexStatistics property is set to FALSE.

The temp-table gets deleted.

You can access the archived data through the handle returned by the GetIndexStatHistoryHandle() method. If you do not specify a value greater than zero for -ttindexrangesize parameter, an error is raised when the ArchiveIndexStatistics property is set to TRUE.

Data type:

LOGICAL

Access:

PUBLIC STATIC

Applies to:

Progress.Database.TempTableInfo class