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