|
|
|
A Full-Text Search (FTS) provides fast, efficient access to character-type data elements. A Full-Text Index (FTI) can be defined by specifying which character-type fields to include in the index. Once an FTI is defined for a file, it is maintained in “real-time” along with any other b-tree type c-tree indices, including deferred index support. FTS allows you to specify a word or phrase for which you are searching. All records whose FTI-indexed fields contain that text are returned.
FTS operations are theoretically possible on a Partitioned File and a FILESET, although verification is still required. Furthermore, because a FILESET is a collection of individual files, FTS could be performed on an individual member file, however, this needs to be verified as well.
A Full-Text Index cannot be used as a partition index.
