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