Kbase P120918: What do the columns of the PROUTIL IXANALYS indicate ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/06/2009 |
|
Status: Unverified
GOAL:
What do the columns of the PROUTIL IXANALYS indicate ?
GOAL:
What do the columns of the PROUTIL IDXANALYS indicate ?
GOAL:
How to improve an index' utilization rate ?
FACT(s) (Environment):
All Supported Operating Systems
Progress 7.x
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
The most important field in the IXANALYS display is the %Util field.
This field shows the degree of consolidation of each index. If an index is several hundred blocks, and your application most frequently retrieves data, an index utilization of 85 percent or higher is optimal. There are two ways to increase an index's utilization rate:
Compress the index with the database online or offline with the PROUTIL IDXCOMPACT utility.
Rebuild and compress the index offline with the PROUTIL IDXBUILD utility.
The Levels field shows the number of reads Progress performs in each index per entry.
The Blocks and Bytes fields show you the size of each index.
The Factor field is based on the utilization and size of the index; it is an indicator of when you should rebuild indexes.
When you use the factor field to decide whether to rebuild an index, consider the context of how the particular index is used. For example, if an index is highly active, with continuous insertions and deletions, its utilization rate varies greatly, and a rebuild is inadvisable. However, a static index with a high factor value benefits from a rebuild.