Addition or updating of row data in a table for which a plug-in index is defined requires that keys be added to the plug-in index. When a large amount of row data is added or updated, the resulting addition of keys to the plug-in index can degrade performance.

Instead of adding the plug-in index data at the time the row data is added, the database reorganization utility (pdrorg) can be used at a later time to add the plug-in index data in a batch; this is called delayed batch creation of a plug-in index. Figure 10-2 shows delayed batch creation of a plug-in index.

Figure 10-2 Delayed batch creation of plug-in index

Prerequisite

It must be determined whether or not the plug-in being used supports delayed batch creation of plug-in index. Delayed batch creation of plug-in index cannot be used for a plug-in that does not support this facility.

The HiRDB Text Search Plug-in supports delayed batch creation of plug-in index.

Advantage

Because data is not added to the plug-in index, the execution time (table data creation time) for a UAP that adds or updates a large volume of data can be reduced considerably.

Operating procedure

For details about the operating procedure for using delayed batch creation of plug-in index, see the HiRDB Version 8 System Operation Guide.