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