Kbase 63596: Speeding up the creation of indexes in conversion
| Autor |
Tatiane Koslinsky - CAT |
| Acesso |
Público |
| Publicação |
9/26/2017 |
|
The dictionary correction stage, among other activities, is responsible for creating indexes in the database.
When indexes are created in tables with large volumes of data, it might be better to make them inactive and then reactivate them through the 'PROUTIL <bank> -C IDXBUILD' command.
To do this, change the .df files in the 'dfcorr' directory, including the word 'INACTIVE' in the index definition, as shown in the example below:
ADD INDEX "Comments" ON "Customer"
AREA "Customer Index Area"
INACTIVE
WORD
INDEX-FIELD "Comments" ASCENDING
This makes importing these settings faster because indexes will not be created, only be cataloged in the data dictionary.
After the import is complete, use the PROUTIL command to re-create the inactive indexes. Here is a brief example:
proutil sports -C idxbuild <performance parameters>
- Select option 'v' = Rebuild selected active or inactive indexes
- Select option '2' = Choose inactive indexes
- then answer the other questions relevant to reindexing
This other article contains more information on how to improve reindexing performance in Progress 10.2B08 or higher.