Kbase P50274: Differences for idxbuild with or without sorting
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Differences for idxbuild with or without sorting
FIX:
When no sorting is done on "idxbuild", there are two phases:
Phase 1. The utility scans the database file, clearing all index blocks that belong to the indexes you are rebuilding and adding these blocks to the free block list.
Phase 2. The utility scans the database file and rebuild all the index entries for every data record and writes the index entries to the appropriate index.
When sorting is done, then phase 2 is different and a phase 3 is needed:
Phase 2. The utility scans the database file and rebuild all the index entries for every data record and writes the entries to the sort file.
Phase 3. The utility sorts the index entries in the sort file into groups and enter those entries into their respective entries in order, one index at a time.