> #### Db_TabAnalysis table

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

> Table 3–18: Db_TabAnalysis table details
> Field name | Data type | Description | Default value
> --- | --- | --- | ---
> Tab_ID | Integer | Sequential ID of the row. | Next ID
> Tab_TableName | Character | Table name used by the table. Tab_TableName is the same as _File-name. | N/A
> Tab_RecordCount | Integer | The number of records in the table. | N/A
> Tab_Bytes | Integer | The size, in total bytes, of all of the records in this table. | N/A
> Tab_MinRecSize | Integer | The size, in bytes, of the smallest record in this table. | N/A
> Tab_MaxRecSize | Integer | The size, in bytes, of the largest record in this table. | N/A
> Tab_AveRecSize | Integer | The average record size, in bytes, for records in this table. | N/A
> Tab_FragmentCount | Integer | A count of how many records within the database that were required to be physically split. | N/A
> Tab_FragmentFactor | Decimal | A factor of how many records within the database that were required to be physically split. | 1
> Tab_ScatterFactor | Decimal | Indicates how far between records within the database. | N/A
> Tab_ResrcName | Character | The name of the database resource. | N/A
> Tab_Date | Date | This is the date that the analysis was run. It is extracted from the report. | N/A
> Tab_Time | Integer | This is the time that the analysis was run. It is extracted from the report. | N/A
> Site_ID1 | Character | The Site_ID for the database. | N/A
> Resrc_ID1 | Integer | The Resource ID of the database for this site. | N/A
> The Site_ID and Resrc_ID fields are included in the table definitions. They are not required fields. However, they add value by providing the capability to tie the dbanalysis information back to the other information for that same database.

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