Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Index activity (_ActIndex)
 
Index activity (_ActIndex)
The _ActIndex VST displays index activity, such as the number of entry finds, creates, and deletes, the number of locked entries removed, and the numbers of split and free blocks.1
Field name
Data type
Description
_Index-Create
INT64
Number of new index entries generated
_Index-Delete
INT64
Number of index entries deleted
_Index-Find
INT64
Number of times an index entry was looked up
_Index-Free
INT64
Number of index blocks freed during deletes
_Index-PartitionId
INTEGER
Partition Id of the index
_Index-Remove
INT64
Number of locks released at transaction end
_Index-Splits
INT64
Number of block splits resulting from index additions
_Index-Trans
INT64
Number of transactions committed
_Index-UpTime
INTEGER
Number of seconds the database was up
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.