Text indexes are supported for IQ v15.2 and higher and enable fast full text searching.
You create a text index by creating a standard index (see Creating an Index), and selecting the type TEXT.
The following additional extended attributes are available on the Sybase tab for text indexes:
|
Name |
Description |
|---|---|
|
Configuration |
Specifies the text configuration (see Text Configurations) to be used to control the building of the text index. Scripting name: Configuration |
|
Immediate refresh |
Specifies that the index is refreshed immediately each time data is written to the table. Scripting name: Refresh |