Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Index statistics (_IndexStat)
 
Index statistics (_IndexStat)
The _IndexStat VST displays statistics on the number of accesses to a specific range of indexes.1
Field name
Data type
Description
_IndexStat-Blockdelete
INT64
Number of block deletes that have occurred to the index
_IndexStat-Delete
INT64
Number of times delete access has occurred to the index
_IndexStat-Create
INT64
Number of times create access has occurred to the index
_IndexStat-id
INT64
Represents the index number. The _IndexStat table is identified by the index number. The _IndexStat-id field of the first row of the _IndexStat table is equal to or greater than the value specified by the -baseindex startup parameter.
_IndexStat-Read
INT64
Number of times read access has occurred to the index
_IndexStat-OsRead
INT64
Number of index reads from disk since the database was started.
_IndexStat-PartitionId
INTEGER
Partition Id of the index
_IndexStat-Split
INT64
Number of split operations that have occurred to the index

1 Activity and status of ABL temp-tables is available in this virtual system table. The statistics gathered allow you to monitor the operation and performance of deployed client temp-tables. Specify the range of temp-tables to track with the -ttbasetable and -tttablerangesize startup parameters. Specify temp table indexes with -ttbaseindex and -ttindexrangesize startup parameters. For more information monitoring and debugging temp tables with VSTs, see OpenEdge Development: Debugging and Troubleshooting.