13.4 Plug-in index

This section describes plug-in indexes.

Organization of this section
(1) Effects of plug-in indexes
(2) Creation procedure
(3) Notes
(4) Batch creation of plug-in index

(1) Effects of plug-in indexes

Improved performance
When a plug-in is used, table retrieval performance can be improved by creating a plug-in index. The user can execute complicated retrieval processing at high speed by using the index types provided by plug-ins.

(2) Creation procedure

The CREATE INDEX definition SQL is used to create a plug-in index for a table.

(3) Notes

Some plug-ins require definition of a plug-in index. If a function that uses a plug-in index is specified without the plug-in index having been defined, an error may result during execution.

(4) Batch creation of plug-in index

You can use the database load utility (pdload) to create a plug-in index in the batch mode. For details about batch creation of a plug-in index, see 6.4 Creating a table containing a plug-in-provided abstract data type.