The following table identifies the table contents of the Ar_ActIdx table (the archived version of the database table ActIdx), which stores index data about overall performance.

Table 1. Contents of the Ar_ActIdx table
Field name Data type Description
ActIdx_Create Decimal Number of index keys created
ActIdx_Delete Decimal Number of index keys deleted
ActIdx_Find Decimal Number of index keys requested
ActIdx_Free Decimal Number of index blocks placed on the free chain
ActIdx_Remove Decimal Number of deleted blocks removed at the end of a transaction
ActIdx_Splits Decimal Number of index block splits performed
ActIdx_User1 Character User-definable field
Sample_ID Integer Identification number of the gathered sample
ActIdx_ArchiveType Character Identifies the field's archive type:
  • H — Hourly
  • D — Daily
  • W — Weekly
ActIdx_Length Integer Number of seconds for the archive to take place
ActIdx_StartDate Date Start date for the row (this date will always be the same as the end date for hourly and daily)
ActIdx_StartTime Integer Start time for the row
ActIdx_EndDate Date End date for the row
ActIdx_EndTime Integer End time for the row
ActIdx_Transactions Integer Number of transactions committed
ActIdx_RecordCount Integer Number of records in this archived file
Resrc_ID Integer The Resource ID of the database for this site
Site_ID Character The Site_ID for the database