> #### Complete contents of an archived table

> Table 3–17 identifies the table contents of the Ar_ActIdx, the archived version of the database table ActIdx, which stores index data about overall performance.

> 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.

Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095