Table 3–17: 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 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.
|