Text Indexes

Create, delete, generate DDL, and manage the properties of 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.

Text indexes significantly speed up full-text searching. You must configure a text index for a table before it is subjected to a full-text search.

Each text index requires a text configuration object. SAP provides two default text configuration objects, one for CHAR collation, one for NCHAR collation. When you set up a text index, you can use one of the default text configuration objects or create a custom text configuration object.

In the SAP Sybase IQ documentation, see IQ-product-name Unstructured Data Analytics for detailed information on text indexes.

• Creating a Text Index
  Set up a text index for a table.
• Deleting a Text Index
  Remove one or more text indexes.
• Refreshing a Text Index
  Refresh a text index for a system store (IQ catalog store) table to bring it up to date when the underlying data has changed.
• Truncating a Text Index
  Truncate a text index for a system store (IQ catalog store) table.
• Generating Text Index DDL Commands
  Generate data description language for one or more text indexes. The DDL code can be a useful reference and training tool.
• Viewing or Modifying Text Index Properties
  Display or change the properties of a text index for a main store or catalog store table.
• Text Index Privilege Summary
  A list of the system privileges and object permissions required to complete the various text index tasks.