5.4 Designing a text index

This section explains what must be considered when designing a text index.

You use the CREATE INDEX statement to define text indexes.

Important

You cannot define a text index for a column store table.

Organization of this section

• 5.4.1  Points to consider in determining the columns to be defined for a text index

• 5.4.2 Allocating an unused area inside a text index page (PCTFREE)

• 5.4.3 Notes on defining text indexes (unfinished status of text indexes)

• 5.4.4 Notation-correction-search text-index specification (CORRECTIONRULE)

• 5.4.5 Specifying a text index for a word-context search (TEXT WORDCONTEXT)

• 5.4.6 Selecting the delimiting characters for word-context searches (DELIMITER)

To Page Top