NGRAM TEXT Index

NGRAM TEXT index stores the text in the column by breaking the text into n-grams of text value N, where N is the value given by a user.

You can perform a search over an NGRAM TEXT index by matching the n-grams of the text value in the CONTAINS clause of the query against the stored n-grams in the index.

NGRAM TEXT index accommodates fuzzy searching capability over the text for both European and non-European languages.

Note: NGRAM TEXT index search is mainly useful when words are misspelled. SAP Sybase IQ does not support searches like synonyms and antonyms.

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.