Creating a Signature Text Index |
Signature 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, and text indexes can be built on multiple columns.
To ensure optimal performance for a signature text index, specify the total text size and the scale. 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-200 MB, and the default total text size value is 32 MB.
The scale is the relative size of the text index to the total text size expressed as a percentage. Generally the larger the scale the better the query performance. The default scale is 50 percent.
Text indexes may be sorted by using the order by feature
Related topic: