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)