> #### Db_IdxAnalysis table

> The Db_IdxAnalysis table stores all of the information related to index analysis for a specific table, refers back to the Cf_Resrc and Cf_Site table using appropriate IDs, and stores the resource name.

> Table 3–19: Db_IdxAnalysis table details
> Field name | Data type | Description | Default
> --- | --- | --- | ---
> Tab_ID | Integer | The sequential ID of the row. | Next ID
> Idx_TableName | Character | The table name that the index references. Idx_TableName is the same as _File-name. | N/A
> Idx_Number | Integer | The index number for the index within the database. | N/A
> Idx_Bytes | Decimal | The size, in total bytes, of all of the index entries in this index for this table. | N/A
> Idx_Blocks | Decimal | The number of blocks in this index. | N/A
> Idx_UtilizationPct | Decimal | The percentage of index blocks that are filled. | N/A
> Idx_Utilization Factor | Decimal | The average number of blocks between which the index is split. | N/A
> Idx_IndexName | Character | The name of the index. | N/A
> Idx_Levels | Decimal | Indicates how many levels deep the index traverses. | 1
> Idx_ResrcName | Character | The name of the database resource. | N/A
> Idx_Date | Date | This is the date that the report was run. It is extracted from the report. | Report's content
> Idx_Time | Integer | This is the time that the report was run. It is extracted from the report. | Report's content
> Site_ID | Character | The Site_ID for the database. | N/A
> Resrc_ID | Integer | The Resource ID of the database for this site. | N/A

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