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
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |