Kbase P129142: Can we determine the order in which indexes will be rebuilt in an area when doing a rebuild "all" f
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/02/2008 |
|
Status: Unverified
GOAL:
Can we determine the order in which indexes will be rebuilt in an area when doing a rebuild "all" for the area?
GOAL:
What is the index rebuild order for a database?
FACT(s) (Environment):
OpenEdge 10.x
All Supported Operating Systems
FIX:
Yes, the order can be determined by looking to the sort groups. The sort group in an area that is used by an index is determined by the (index number) mod (total srt group (SG) number).
Examples from 10.1A which has a default SG of 48:
1. Index 48 in an area:
48 mod 48 = 0
index 48 will be located in srt group 0
It will be rebuilt first.
2. Index 23 in the same area:
23 mod 48 = 23
Any number less than 48 divided by 48 will be 0 with itself as the remainder.
Index 23 will be in sort group 23 and get rebuilt after index 48 located in the first sort group, group 0.
Based on the area, you may not use all 48 srt groups.
The order in which indexes will be rebuilt in an area is based on which sort group they are placed in, starting with group 0 and going through group 48.