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.