Kbase P46656: Why idxbuild can improve performance?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Why idxbuild can improve performance?
GOAL:
Why idxcompact can improve performance?
FIX:
Running idxbuild or idxcompact (with "proutil" utility) can improve performance as it may reduce the number of index blocks to access while updating, adding or deleting records.
Check the file resulting from a "proutil <db> -C idxanalys" or "proutil <db> -C dbanalys" before and after the idxbuild or idxcompact and see the changes for the number of blocks for each index.
See below an extract of idxanalys showing that the "orderLine" index on "OrderLine" table has 139 blocks.
INDEX BLOCK SUMMARY FOR AREA "Order" : 11
-------------------------------------------------------
Table Index Fields Levels Blocks Size % Util Factor
PUB.OrderLine
itemnum 23 1 2 56 36.7K 67.4 1.9
orderline 22 2 3 139 132.7K 98.2 1.0
OrderLineStatus 24 1 2 10 7.2K 74.1 1.8