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. The figure below shows delayed batch creation of a plug-in index.

When the system switchover facility is being used, the index information file must be created on the shared disk. In addition, when the system switchover facility is being used in the UNIX edition, the index information file must be created in a HiRDB file system area (character special file) on a shared disk.

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

Prerequisite

It must be determined whether 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 9 System Operation Guide.