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