Manage Text Indexes

Create, delete, generate DDL, and manage the properties of text indexes and text configuration objects.

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. Sybase 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.

For detailed information on text indexes, see Unstructured Data Analytics in Sybase IQ.

• Creating a Text Index
  Set up a text index for a table in Sybase IQ.
• Modifying the Properties of a Text Index
  Display and change the properties of a text index for a Sybase IQ table (column store) or a catalog store table (row store).
• Generating DDL for a Text Index
  Generate data description language for one or more text indexes. The DDL code can be a useful reference and training tool.
• Refreshing a Text Index
  Refresh a text index for a 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 catalog store table.
• Deleting a Text Index
  Remove one or more text indexes.