Text configuration objects and TEXT indexes have limitations by design.
SAP Sybase IQ does not provide support for TEXT indexes spanning multiple columns.
TEXT index manual refresh or automatic refresh options are not supported.
sp_iqrebuildindex cannot be used to build TEXT indexes.
You cannot create TEXT indexes within BEGIN PARALLEL IQ…END PARALLEL IQ.
NGRAM term breaker is built on TEXT indexes, so use text configuration object settings to define whether to use an NGRAM or GENERIC TEXT index.
NGRAM TEXT index search is mainly useful when words are misspelled. SAP Sybase IQ does not support searches like synonyms and antonyms.