Try OpenEdge Now
skip to main content
Trend Database Guide and Reference
OpenEdge Management Trend Database Schema : Database analysis tables : Db_IdxAnalysis table
 

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 20. 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_AreaName
Character
Database Index Area Name
N/A
IDX_Number
Int64
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
The date on which the report was run; it is extracted from the report
Report's content
IDX_Time
Integer
The time at which 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