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
|