Working with IVF Text Indexes |
|
Inverted file (IVF) text indexes are a type of text index built on files separate from the tablespace that the columns are stored in. As a result, query performance is significantly better for larger text indexes. You need to create a logical path for the IVF text index files to be stored in before creating an IVF text index. Logical paths are specified in the JConfiguration Tool or by modifying the DMConfig.ini file. Once the path is specified, DBMaker handles the creation of files for use in the IVF text index.
Since IVF text indexes are a part of the operating system's file system, they may be liable to fragmentation. Be sure to specify a logical path on a reserved partition and periodically defragment the partition to ensure optimal performance.
Once you create an IVF text index on a table, its operation is transparent to users of the database. The DBMS uses the IVF text index to improve full-text query performance whenever possible.
Related topic:
Creating
an IVF Text Index
Dropping an IVF Text Index
Rebuilding an IVF Text Index
Checking IVF Text Index Statistics