Kbase P56448: What is done during phase 1 of idxbuild?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
What is done during phase 1 of idxbuild?
FACT(s) (Environment):
Progress 9.x
FIX:
Starting with V9 idxbuild phase 1 includes
.the scan of the area(s) containing the index(es) to rebuild, clearing all index blocks that belong to the indexes to be rebuild and adding these blocks to the free block list
and
. the scan of the area(s) containing the concerned table(s), rebuilding all the index entries for every data record and writing the entries to the sort file.
The larger the storage areas to be scanned are, the longer the duration of phase 1 will be.
Prior to V9, the phase 1 was the scan of the database file for clearing all index blocks that belong to the indexes to be rebuild and adding these blocks to the free block list; the scan of the data blocks was done within phase 2. There was no possibility to skip scanning blocks of not related tables or indexes, storage areas did not exist.