Kbase P115915: Is it normal for the extents in an index area to grow during a tablemove
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/7/2009 |
|
Status: Verified
GOAL:
Is it normal for the extents in an index area to grow during a tablemove
GOAL:
Why does the index area extent experience enormous growth during a tablemove?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
During a tablemove, the indexes are rebuilt even if not moved. All new indexes are built, but the old indexes are not deleted until the tablemove has completed. This accounts for the growth seen in the index area during a table move. This could be more than double the space required for the indexes of the table being moved.