Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : User index activity (_UserIndexStat)
 
User index activity (_UserIndexStat)
Displays statistics on the number of accesses to a specific range of indexes by user.1
Field name
Data type
Description
_UserIndexStat-Conn
INTEGER
User number
_UserIndexStat-Num
INTEGER
Index number
_UserIndexStat-blockdelete
INT64
Number of block deletes that have occurred to the index by the specified user
_UserIndexStat-create
INT64
Number of times create access has occurred to the index by the specified user
_UserIndexStat-delete
INT64
Number of times delete access has occurred to the index by the specified user
_UserIndexStat-PartitionID
INTEGER
Partition Id of the index
_UserIndexStat-read
INT64
Number of times read access has occurred to the index by the specified user
_UserIndexStat-TenantID
INTEGER
Tenant ID of the user
_UserIndexStat-split
INT64
Number of split operations that have occurred to the index by the specified user

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.