Creating an IVF Text Index |
IVF Text indexes can be built on all character type columns, including CHAR, VARCHAR, LONG VARCHAR, NCHAR, NVARCHAR, NCLOB, and FILE types. A table can have multiple text indexes, but a text index can only be built on a column. If you need to perform full-text search for other columns, you should build an index for each column.
The three parameters used for IVF text indexes include the storage path, the total text size and the scale. The storage path is the location of the IVF text index in the file system. A path must be specified in the configuration file before using an IVF text index. For more information on the storage path for IVF text indexes, refer to the JConfiguration Tool Reference.
The total text size is an approximation of the total number of megabytes of storage that are used by the columns on which the text index is to be built. The total text size can range from 10-10,000 MB, and the default total text size value is 32 MB.
IVF text indexes may be sorted by using the order by feature
Related topic: