To use TEXT indexes, you must be
specifically licensed to use the unstructured data analytics functionality.
See Unstructured Data Analytics in Sybase IQ.
Unlike a Containment (WD) index, which uses keywords in a column string, 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.
