Users must have the Unstructured Data Analytics license
to use the full text search functionality.
Full text searching increases the Sybase IQ ability to handle unstructured and semistructured data.The new full text search capability in Sybase IQ 15.2 is based on the use of a new index for columns of text data in many forms. The new index provides fast results to queries on columns containing a term or phrase.
When you perform a full text search, you are searching a TEXT index (not table rows). Before you can perform a full text search, create a TEXT index on the column to search. A TEXT index stores positional information for terms in the indexed columns. Queries that use TEXT indexes can be faster than those that must scan all the values in the table.
A text configuration object is used when creating the TEXT index. The object controls the terms that get stored in a TEXT index and how a full text query is interpreted.
See Unstructured Data Analytics in Sybase IQ.
