TEXT Indexes and Text Configuration Objects

Learn about working with TEXT indexes and text configuration objects.

A TEXT index stores positional information for terms in an indexed column. TEXT indexes are created using settings stored in a text configuration object. A text configuration object controls characteristics of TEXT index data, such as terms to ignore, and the minimum and maximum length of terms to include in the index.

• TEXT Indexes
  In a full text search, a TEXT index is searched, rather than table rows.
• 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.
• Text Configuration Objects
  Text configuration objects control the terms that are placed in a TEXT index when it is built or refreshed, and how a full text query is interpreted.