Working with Signature Text Indexes |
|
A text index is a mechanism that provides fast access to rows of a table containing columns with one or more words or phrases as text. Text indexes contain a representation of all the text found in the text columns on which they are based. However, the data is encoded and structured to make retrieval much faster than directly from the table. Once you create a text index on a table, its operation is transparent to users of the database. The DBMS uses the text index to improve full-text query performance whenever possible.
Signature text indexes are created within the same tablespace as the columns that the index is being created for. Signature text indexes are well suited for building on columns that contain a combined total of 200 or fewer MB of data. For larger text indexes, consider building an inverted file (IVF) text index. For detailed information on IVF text indexes, refer to Working with IVF Text Indexes.
Related topic:
Creating
a Signature Text Index
Dropping a Signature Text Index
Rebuilding a Signature Text Index
Checking Signature Text Index Statistics