Kbase P186369: When records are deleted will the index leaf node space for that record be reused.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/25/2011 |
|
Status: Unverified
GOAL:
When records are deleted will the index leaf node space for that record be reused.
GOAL:
When indexes are deleted will the space be reused?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge Category: Database
OpenEdge 10.x
FIX:
If the index entry is truly deleted, the space in the index block will be reused. When all the entries in an index block are deleted, it will become a free block. When an index block in a type II area becomes empty, it is put on the Free chain for the object or if it is a type I area it is placed on the Free chain for the area. In Type I areas the blocks on the free chain can be reused by other objects as well, i.e. records. In a type II area the space freed will only be reused by the same object until the object is deleted.